DSXchange

Have a job that is getting a lot of these errors: APT_CombinedOperatorController(0),1: Expected identifier; got: "*" The job uses a shared container that is being used to convert Julian Dates to Oracle Dates The basic transformer has a stage variable that does a NullToValue(Date,'') and pa...

I just came back from being out a few days, and saw this resolution. I tried to log in as wasadmin and it didnt work. Found out wasadmin was never set up as a user on the websphere server ( we have a 3-tier setup). Having an account created now, but hopefully this still holds true for me. Thanks to ...

Same here. Stopped and restarted WAS several times and Info Server too.
I remember this worked for me back when we upgraded to 8.1.
No dice here on 8.5.
Any other ideas?

Kevin,

You mention restarting Information Server and not Websphere Server.
Have you tried that yet?

Unix :
cd WAS_home/bin
./stopServer.sh server_name [options]
./startServer.sh server_name

refer to :
http://www-01.ibm.com/support/docview.w ... wg21497966

Just setup IA and ran column analysis. Tried to create a report and got this error: com.ascential.acs.reporting.ReportingEngineException: /tmp/informationServer/Reporting(ServerName)Node01server1/engine/JREPORT/realm/defaultRealm/dhtmlPreference.properties (No such file or directory) Checked the web...

I found out that when database is a cluster, I can provide the instance name for one node and the database name and it worked.

Hope this helps someone!

We are setting up our IA environment and I am unable to create a database connection for IA to use for analysis. The IADB is an Oracle database on RAC. I believe RAC setups have no SIDs. I mentioned IADB(Name of database) in "Database Name" and it said it couldnt find the database. I tried...

Yes, we are running 64-bit on RHEL 5.7 64-bit...

Ray, I apologize but I have no idea what that means. I am just using the built in routine WaitForStage and pointing it to a transformer. I tried splitting the job into 2 jobs instead of 2 streams in same job and it works great. Rough sketch: DimLookups | | OracleSource---Xfmr---Xfmr---Aggr---Xfmr---...

I have a simple job that splits rows into 2 streams and then aggregates and writes to one table, with a waitforstage routine to write one after another. I have been able to run the job succesfully for a small subset of rows, but larger sets of data hang the job and it just sits there doing nothing, ...

I installed 8.5 recently and also the FP1 and am currently on 8.5.0.1 on Linux RHEL 5.7 server edition. I am trying to use XML for the first time and tried to import using the Schema Library Manager. But every time I click on it, it comes back with an error: "The remote server returned an error...

Once I explained to my admin what I was trying to do, he set me up in the at.allow and its all good now.

Thanks Craig!

I am still looking to see if I can find the cron.allow and at.allow directories.
But I did find a /var/spool/at directory and asked my admin to give write permissions to dsadm to this. Not sure if this is the right directory, its basically at the same level as the cron is.

Trying to schedule a one time run on Linux RHEL 5.7 in DS 8.5. Searched DSXchange and asked admin to give dsadm permissions to write to atjobs directory, and he goes "what atjobs directory?" I do not have a /usr/spool/cron, but I do have a /var/spool/cron which has the OS level user dsadm ...

I found my answer browsing the web.
I had to add this line to my .odbc.ini entry for the particular AS400 connection:
CharsetFor65535=2028

Hope this helps someone.