DS Common Errors,Warnings and Solutions V1.1

Datastage Most Common Errors,Warnings and Solutions- V1.1

This post will help you to solve your datastage error's and warning.

1. While running ./NodeAgents.sh start command... getting the following error: “LoggingAgent.sh process stopped unexpectedly”

SOL:   needs to kill LoggingAgentSocketImpl

              Ps –ef |  grep  LoggingAgentSocketImpl   (OR)

              PS –ef |  grep Agent  (to check the process id of the above)

2.Warning: A sequential operator cannot preserve the partitioning of input data set on input port 0

SOL:    Clear the preserve partition flag before Sequential file stages.

3.Warning: A user defined sort operator does not satisfy the requirements.

            SOL:   Check the order of sorting columns and make sure use the same order when use join stage after sort to joing two inputs.

4.Conversion error calling conversion routine timestamp_from_string data may have been lost. xfmJournals,1: Conversion error calling conversion routine decimal_from_string data may have been lost

SOL:    check for the correct date format or decimal format and also null values in the date or decimal fields before passing to datastage StringToDate, DateToString,DecimalToString or StringToDecimal functions.

5.“Error trying to query dsadm[]. There might be an issue in database server”

SOL:   Check XMETA connectivity.

db2 connect to xmeta (A connection to or activation of database “xmeta” cannot be made because of  BACKUP pending)

6.“DSR_ADMIN: Unable to find the new project location”

SOL:   Template.ini file might be missing in /opt/ibm/InformationServer/Server.

           Copy the file from another severs.

7. “Designer LOCKS UP while trying to open any stage”

SOL:   Double click on the stage that locks up datastage

           Press ALT+SPACE

           Windows menu will popup and select Restore

           It will show your properties window now

           Click on “X” to close this window.

           Now, double click again and try whether properties window appears.

8.“Error Setting up internal communications (fifo RT_SCTEMP/job_name.fifo)

SOL:   Remove the locks and try to run (OR)

          Restart DSEngine and try to run (OR)

Go to /opt/ibm/InformationServer/server/Projects/proj_name/

ls RT_SCT* then

           rm –f  RT_SCTEMP

           then try to restart it.

9.While attempting to compile job,  “failed to invoke GenRunTime using Phantom process helper”

   RC:     /tmp space might be full

           Job status is incorrect

           Format problems with projects uvodbc.config file

   SOL:   1)         clean up /tmp directory

             2)        DS Director  JOB  clear status file

             3)         confirm uvodbc.config has the following entry/format:

                       [ODBC SOURCES]

                       

                       DBMSTYPE = UNIVERSE

                       Network  = TCP/IP

                       Service =  uvserver

                       Host = 127.0.0.1

 10. No jobs or logs showing in IBM DataStage Director Client, however jobs are still accessible from the Designer Client.

SOL:   SyncProject cmd that is installed with DataStage 8.5 can be run to analyze and recover projects

           SyncProject -ISFile islogin -project dstage3 dstage5 –Fix

11. CASHOUT_DTL: Invalid property value /Connection/Database (CC_StringProperty::getValue, file CC_StringProperty.cpp, line 104)

SOL:   Change the Data Connection properties manually in the produced

DB2 Connector stage.

A patch fix is available for this issue JR35643

1    

      12. SQL0752N. Connect to a database is not permitted within logical unit of work CONNECT type 1 settings is in use.

SOL:   COMMIT or ROLLBACK statement before requesting connection to another database.

      13.Failed to authenticate the current user against the selected Domain: Could not connect to server.

       RC:     Client has invalid entry in host file

Server listening port might be blocked by a firewall

Server is down

      SOL:   Update the host file on client system so that the server hostname can be resolved from client.

Make sure the WebSphere TCP/IP ports are opened by the firewall.

Make sure the WebSphere application server is running. (OR)

Restart Websphere services.

    14.   The connection was refused or the RPC daemon is not running (81016)

         RC: The dsprcd process must be running in order to be able to login to DataStage.
      If you restart DataStage, but the socket used by the dsrpcd (default is 31538) was busy,

                the dsrpcd will fail to start. The socket may be held by dsapi_slave processes that were still running  or recently killed when DataStage was restarted.

         SOL:   Run "ps -ef | grep dsrpcd" to confirm the dsrpcd process is not running.

Run "ps -ef | grep dsapi_slave" to check if any dsapi_slave processes exist. If so, kill them.

       Run "netstat -a | grep dsprc" to see if any processes have sockets that are ESTABLISHED, FIN_WAIT, or CLOSE_WAIT. These will prevent the dsprcd from starting. The sockets with status FIN_WAIT or CLOSE_WAIT will eventually time out and disappear, allowing you to restart DataStage. Then Restart DSEngine.(if above doesn’t work) Needs to reboot the system.

   

   15. "Run time error '457'. This Key is already associated with an element of this collection."

   SOL:   Needs to rebuild repository objects.

a)     Login to the Administrator client

b)     Select the project

c)     Click on Command

d)     Issue the command ds.tools

e)     Select option ‘2’

f)      Keep clicking next until it finishes.

g)     All objects will be updated.