DSXchange

I already have a job that checks using a routine the maxdatetime value, but it throws 'literal not in the format' error. I tried like this : say DtTime = '10-03-2006 08:15:25' Dt = Left(Time, 10) Tm = Right(DtTime, 12) D1 = OCONV(ICONV(Dt, "D/DMY"), "D/MDY[2,2,4]") T1 = OCONV(ICO...

Hi,

I need to check for last updated datetime of the table, for incremental upload.

Vindy

Hi Craig,

here i am using ODBC stage, not OCI stage.

Vindy

Hi OnlineGurus, my routine is like this: MaxVal = "1753-01-01 00:00:00" Temp1 = LEFT(MaxVal,10) Temp2 = RIGHT(MaxVal,8) MaxDate = OCONV(Temp1, "D/YMD[4,2,2]") MaxTime = OCONV(Temp2, "MTS") Ans = MaxDate:" ":MaxTime I am getting the literal error. my doubt is w...

My SQL output is like this: how do i solve this...i tried by adding various formats but still it shows the error. J_Stage_PS_S_BUS_UNIT_RA_CRM..DRS_SRC_PS_BUS_UNIT_TBL_RA: [Oracle][ODBC][Ora]ORA-01861: literal does not match format string J_Stage_PS_S_BUS_UNIT_RA_CRM..DRS_SRC_PS_BUS_UNIT_TBL_RA: SQL...

Hi,

I am getting following error, how to solve it.

J_Stage_PS_S_BUS_UNIT_RA_CRM..DRS_SRC_PS_BUS_UNIT_TBL_RA: [Oracle][ODBC][Ora]ORA-01861: literal does not match format string.

Regards,
Vindy

Hi Chulett,

I get this error when i run the individual job in designer.

J_Stage_PS_S_BUS_UNIT_FS_CRM..DRS_SRC_PS_BUS_UNIT_TBL_FS: ORA-00942: table or view does not exist

I have given required parameter settings for the connectivity. i dont know where it goes wrong.

Vindy

Hi Deepak,

Is this one related to loading of PS data to PS EPM db?

Vindy

Hi,

Following is the error message i get

Message: SEQ_J_Stage_PS_S_BUS_UNIT_FS_CRM..JobControl (fatal error from SEQ_J_Stage_PS_S_BUS_UNIT_FS_CRM): Job Failed.

Vindy

Hi,

When i try to run a sequence job i am getting ABORT message. i tried importing table definitions, i tried running a job within the sequence individually, but still the error persists.

Thanks in advance,
Vindy

Hi,

Is there any error message pdf file available for DataStage just like BO has one. That'll be very immense help for basic initial errors.

Anyone having can share it.

Thanks,
Vindy

Hi OnlineGurus, I had an issue with connecting DRS Stage so my DBA modified some parameters in dsenv in the server. He shutdown the server and restarted it. From then on I am not able to connect to the server which i was able to do prior. I get the error 'Error 81016 - conn was refused or RPC daemon...

Hi Chitu,

Please Check whether u have entered parameters values correctly and compiled all your jobs.

Check whether u r able to open a job in a sequence and able to get the values of source table. (ie, view data in the DRS stage)

Vindy

Hi Guruji's, I am trying to run a Sequence Job in Datastage Director but i am getting 'Abort' message in log file. here it is - SEQ_J_Stage_PS_S_BUS_UNIT_FS_CRM..JobControl (DSWaitForJob): Job J_Stage_PS_S_BUS_UNIT_FS_CRM has finished, status = 3 (Aborted) SEQ_J_Stage_PS_S_BUS_UNIT_FS_CRM..JobContro...

Hi Onlinegurus, I am trying to run delivered jobs for loading PS CRM Data to PS EPM. when i tried to run 1 job ie, loading Hash table ( J_HASH_PS_BUS_UNIT_TBL_FS_CRM ) i find no datas are populated... Note - i am following the steps delivered by EPM_ETL_Implementation steps.pdf Anyone having exposur...