Search found 105 matches

by JeroenDmt
Mon Dec 08, 2008 3:28 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Error on SET.FILE.MAP RT_BP3 NONE FORCE command (Failed to s
Replies: 15
Views: 12535

Error on SET.FILE.MAP RT_BP3 NONE FORCE command (Failed to s

We are trying to import a dsx-file in another environment. This is the first project we're rolling out in Datastage 8. When importing the dsx-file we are getting a whole series of error messages like Error while creating job <jobname> Error on SET.FILE.MAP RT_BP3 NONE FORCE command (Failed to set fi...
by JeroenDmt
Thu Nov 13, 2008 2:32 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Datastage/Oracle configuration
Replies: 7
Views: 5895

This problem has been solved. Executing the unix command sh -c "ldd /appl/dstadm/IBMIS/Server/DSComponents/bin/oraoci9.so" from within the project showed that the user did not have read-permissions for an Oracle library. After changing the permissions for the library, the jobs are running ...
by JeroenDmt
Mon Nov 10, 2008 2:08 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Datastage/Oracle configuration
Replies: 7
Views: 5895

What you need to do is: 1. Go to Information Server-->Users and Groups to create a new user. 2. Go to Domain Management-->DataStage Credentials, then map and assign this new user's credential with the dsadm's ID and password. You don't even need to create a new user on the Unix box. We do need the ...
by JeroenDmt
Mon Nov 10, 2008 2:33 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Datastage/Oracle configuration
Replies: 7
Views: 5895

dsadm does not have a .profile file in its home directory. Datastage is started by dsadm through a shell-script that includes a call to ". /appl/dstadm/IBMIS/Server/DSEngine/dsenv" When I su to dsadm, I can get to Oracle (sqlplus) after executing dsenv. The new user does not have Oracle li...
by JeroenDmt
Fri Nov 07, 2008 1:29 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Datastage/Oracle configuration
Replies: 7
Views: 5895

Datastage/Oracle configuration

So far we have been using dsadm to run jobs and connect to Oracle and everything worked fine. Now we are having a new Datastage user using another unix-user's credentials to do the same and we are having problems connecting to Oracle. Other Datastage jobs are running fine, but when we try to connect...
by JeroenDmt
Thu Nov 06, 2008 7:52 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Error: C Stage Plugin function only as a new datastage user
Replies: 2
Views: 1862

Arnd, I'm on this with Roy. We are having this problem when using the Oracle OCI stage. When we execute the job using dsadm, everything works fine. When we run the same job using another unix-user's credentials, we get error messages: - ds_loadlibrary: error in dlopen - CreateNotificationMail..XFM_L...
by JeroenDmt
Fri Oct 31, 2008 4:47 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Owner of files when using Websphere Datastage
Replies: 1
Views: 857

Owner of files when using Websphere Datastage

We are converting from datastage 7 to datastage 8. When using DS7 we have a datastage user and when creating files in a datastage server job this user is also the owner of the files on unix. When using DS8 the same files are created but now with owner dsadm. Can this be changed or is the datastage e...
by JeroenDmt
Thu May 08, 2008 8:05 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Abnormal termination XML stage
Replies: 2
Views: 1709

I get the abnormal termination with both the url method or the content method. The filecontents are like this: <reports> <rapportage>..fields with content..</rapportage> <rapportage>..fields with content..</rapportage> .. <rapportage>..fields with content..</rapportage> </reports> I don't know how I...
by JeroenDmt
Thu May 08, 2008 3:42 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Abnormal termination XML stage
Replies: 2
Views: 1709

Abnormal termination XML stage

When reading an xml-file using the XML Input stage, we are getting an error "Abnormal termination of stage <stagename> detected" This error occurs when the xml files are larger than about 6 MB. When we split the xml file into several smaller files, the job runs normally. Is there a limit t...
by JeroenDmt
Mon Nov 26, 2007 1:03 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Datastage 8 installation/ compilation problem
Replies: 13
Views: 6848

If you have both these downloads, NET 2005 Express Edition C++ and SDk, installed BEFORE installing DS/QS 8.0.1, then the Enterprise Edition installer will find them for you, otherwise EE assumes that the compiler and SDK are installed in their default locations. They were installed before installi...
by JeroenDmt
Mon Nov 26, 2007 10:24 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Datastage 8 installation/ compilation problem
Replies: 13
Views: 6848

I "fixed" the problem. The microsoft platform sdk was installed in a directory "c:\program files\Microsoft Platform SDK for Windows Server 2003 R2". When I copied the lib directory from there to "c:\program files\Microsoft Platform SDK" it can compile jobs without a pro...
by JeroenDmt
Mon Nov 26, 2007 10:23 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Datastage 8 installation/ compilation problem
Replies: 13
Views: 6848

iDomz wrote:That was the setting on my server on win 2k3,IIS 8 and VS 2005 Enterprise.

Try installing the latest windows sdk from MS. That should upgrade your libraries and fix any missing dependancies.
I did that, but unfortunately I still got the same error messages when trying to compile.
by JeroenDmt
Mon Nov 26, 2007 10:21 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Problems importing jobs
Replies: 5
Views: 3649

Problems importing jobs

When I try to import a job in a new project, I get an error message: Line 413: The folder \Jobs\MyJobs does not exist.. Object=ROOT. Class=CJobDefn. The job cannot be imported because the MyJobs folder (the folder where the original job comes from) does not exist. The job is exported from another pr...
by JeroenDmt
Fri Nov 23, 2007 10:24 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Remove duplicates stage on data sorted on different keys
Replies: 8
Views: 4098

Why don;t you turn it around?
If you remove the duplicates first and after that you sort it the way you want the result to be sorted, it shouldn't be a problem.
by JeroenDmt
Fri Nov 23, 2007 9:35 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Datastage 8 installation/ compilation problem
Replies: 13
Views: 6848

iDomz wrote:Try adding -W/Zc:wchar_t- to compileropt and linkeropt variables
Then I get the same result.