DSXchange

I need to extract data from a MS Sql table, but I want to do it only if there's a 'load completed' semaphore row in the table. In addition, I want to retry the job once every 15 minutes for one hour. If after an hour the row doesn't exist, I exit with a successful completion code. If I do a 'before ...

"Job xxx is being accessed by another user."

I'm the only user on DS at this time, and I am the owner of that job.

The job is NOT being used.

Help!

cbres00

Yes, I have access to TD.
Disk space....now that may be an issue.


I'll look into that.

Thanks,
CB

I'm trying to move data from Teradata (Teradata Enterprise Stage) to a MS SQL table (DRS stage). I get the following:

main_program: Fatal Error: APT_TeraSync: could not create operator sync table.

I have all the logins and passwords correct.

Regards,
CB

Strangely enough this is a near duplicate of a job I ran just a few minutes before...but it worked that time. Where would I find APT_CONFIG_FILE? In Administrator? We're using Solaris. Thanks cbres00 Hi, Check the disk space on where your datasets are (accoring to the APT_CONFIG_FILE) Check the disk...

node_node1: Fatal Error: Unable to start ORCHESTRATE process on node node1 (slsudv18): APT_PMPlayer::APT_PMPlayer: fork() failed, Not enough space

Regards,
cbres00

I'm trying to use Row Generator to load a test table in Teradata.
I get this strange 'APT_TeraSync: could not create operator sync table' error message.

Any ideas on what this means??

We're on DS 7.1.

Regards,
Cathy

Beauty!

Thanks!
Cathy

Thanks to you both! I'll check after dinner. Mmmmmm!

Cathy

UGH...I can't start DataStage Designer. I just shut it down (bin/uv -admin -stop) and when I start it up (bin/uv -admin -start)it looks fine. Then I try to bring up Designer I get the classic Failed to connect to host: xxxxxx project: yyyy (The connection was refused or the RPC daemon is not running...

Beautiful....but one question: where do I execute this?


Cathy

Is there a way to trace back RT_xxx files to their Designer jobs?

Regards,
Cathy

Ok! Thanks much. CB The easiest way is to have the job write to the base file name then have an after-stage or after-job subroutine run a command to change the name of the file. For example you could invoke ExecSH as the routine, and provide the command mv #FileName# #FileName#_`date +"%Y%m%d&q...

I have a simple job where I am pulling data from a MS SQL table, doing some minor transforms, then writing to a sequential file stage. I want to use time to uniquely identify the filename (I have a param in the job for date). Right now my file name in the sequential stage is my_file_#rundate#.txt Ru...

Thanks for your reply. Would I put the DSGetLinkInfo() in the transformer step that's connected to my MS SQL (dynamic RDBMS) stage? Thanks, CB DataStage keeps a count of the rows sent to the file, which you can subsequently interrogate using DSGetLinkInfo() or DSGetLogEntry() functions. Or you can u...