DSXchange

If it is the Block size issue, the rerun also should fail but rerun is completing successfully.

We are extracting the XML messages from the database.

Also when we rerun the job, its completing successfully.

Hi,

Could someone please assist me on the below error?

Internal Error: (blockSizeActual >= v4BlockHeader::size ()): datamgr/partition.C: 442 Traceback: Could not obtain stack trace; check that 'dbx' and 'sed' are installed and on your PATH

$APT_PLAYER_TIMING will display the timings per node basis, correct me if i am wrong.

Hi,

I am doing the testing for the different scenarios, for each scenario the execution time is vary. I want to understand what is the root cause for this. Can you please let me know how to findout CPU usage by the particular job?

Thanks.

Hi, When I am running the job, it is opening many database connections and going to sleeping mode. I am assuming if we use two database stages ( as source and target) with 3 node configuration, it will open 6 database connections. Once the it reads the data from the database it will not close the co...

Thanks. I am able to store the value in BigInt filed with 5 digit milli seconds.

Thanks. But it is loading into the mysql database as "9223372036854775807" ( some unknown value). While populating into the with Varchar datatype is populating corretly, but the same value while populating into the BigInt column some unknown value is populating.

Ok.

The CurrentTimestampMS() function will return the dateTime along with milli seconds. ( ex: 2012-01-04 16:35:00.189089). I want to store this value as 20120104163500189089 in database ( field datatype is BigInt). Please let me know how i can implement this.

ray.wurlod wrote:Is the Scale value in the metadata set to 6? ...

.

For the BigInt do we need to mentioned the scale value?

pandeesh wrote:Can you check whether your time stamp value has the milli seconds?

.

Yes. the timestamp value is having the milli seconds.

while using the convert function, I am not getting the milli seconds into the result value.

For ex: Convert('-:. ','',2012-01-04 15:43:09.989564). I am getting the result as 20120104154309. But i need the result as 20120104154309989564. Please suggest.

while using the convert function, I am not getting the milli seconds into the result value.

For ex: Convert('-:. ','',2012-01-04 15:43:09.989564). I am getting the result as 20120104154309. But i need the result as 20120104154309989564. Please suggest.

Hi,

Can anyone please let me know how to convert the Timestamp value to BigInt. The reson is we are using the MySql as database but we need to store the milli seconds also.

For Ex: 2012-01-04 11:12:13:001 to 20120104111213001

Thanks.

Hi,

How can I perform the A= A + B manipulation in loop. Because i have the requirement like i will generate multiple output files using same job and need to take the count of each file and sum it up and update into the audit table.

Please let me know how can i implement the above scenario.