DSXchange

Hi ,
The job in production is failling throwing the below error:
AggPrdRollUp,3: Caught exception from runLocally(): APT_BadAlloc: Heap allocation failed..
how to overcome this ?

Hi , we are facing a data conversion error while executing a query in ODBC stage.The DB:oracle. we are using the NLS character map <ISO-8859-1>(project default). There is one error with the week_st_dt column.The datatype of this column in source table is "Date" .In the query we are changin...

Hi , i have situation where i need to combine two hash files.The first hash file has got compound unique key.The second file also has got compound unique key. Thevalues in the hash file looks like this... Hash file 1: A1 B1 C1 D1 (combination of 4 values is unique) A1 B1 C1 D2 A2 B1 c1 D1 . . Hash f...

OpenSeq FilePath To vInput Else Call DSLogWarn("Cannot open ":FilePath , BatchName) GoTo ErrorExit Done = @TRUE End Loop ReadSeq vLine From vInput On Error Call DSLogWarn("Error from ":FilePath :" status=":Status(),BatchName) GoTo ErrorExit Done = @TRUE End Then hJob1 ...

Already the OPENSEQ is present outside of loop only. secondly the column name is COLUMN1 only ... CODE: OpenSeq FilePath To vInput Else Call DSLogWarn("Cannot open ":FilePath , BatchName) GoTo ErrorExit Done = @TRUE End Loop ReadSeq vLine From vInput On Error Call DSLogWarn("Error fro...

Hi all, we are facing a unique problem after we moved the jobs from version 6 (server jobs)to version 7.1.we are using BASIC function in our code. Problem 1: The BASIC is used to read records from the sequential file.The sequential file contains about 4 records which are not unique.The BASIC functio...

I used @inronum and KEYGen routine.one more thing which i forget to add is the batch job which uses this hash file clears the hash file content at the end of the batch run.So in the next run the hash file will have no records in it.

Hi , i have situation where DS job multiple times and appends records into hash file which doesnt have the unique value.so i am trying to create the surrogate key in transformer stage and append the data based on the SGkey value. i tried few logics but nothing is working out ..how to go about it... ...