problem with the teradata
Moderators: chulett, rschirm, roy
problem with the teradata
hi,i am using teradata enterprise stage to load the data from a dataset.i am using replace option ie, drop the table then create a new table and load the data.The same job working in development box, but it is giving warnings on the system test box.following is the error.
APT_TeraWriteOperator:DB Call Failure(success check) Info = 0, Code = 3593, Message = No DATA parcel sent and request uses a USING clause.
APT_TeraWriteOperator:ExecuteImmediate failed for 'USING CIDPERSID(integer), PRDID(integer), SRC_SYS_KEY(varchar(20)) INSERT INTO BADA_PDW_SYT.DA_PDW_CC1K (CIDPERSID, PRDID, SRC_SYS_KEY) VALUES (:CIDPERSID, :PRDID, :SRC_SYS_KEY)'.
can naybody tell me what is the problem.Thanks for your help
APT_TeraWriteOperator:DB Call Failure(success check) Info = 0, Code = 3593, Message = No DATA parcel sent and request uses a USING clause.
APT_TeraWriteOperator:ExecuteImmediate failed for 'USING CIDPERSID(integer), PRDID(integer), SRC_SYS_KEY(varchar(20)) INSERT INTO BADA_PDW_SYT.DA_PDW_CC1K (CIDPERSID, PRDID, SRC_SYS_KEY) VALUES (:CIDPERSID, :PRDID, :SRC_SYS_KEY)'.
can naybody tell me what is the problem.Thanks for your help
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
What's different between the system where it is working and the system where it is not? Please consider non-DataStage differences as well, particularly differences in Teradata settings.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Perhaps siva4joy can, since the thread has been marked as resolved.
Customary practice here on DSXchange is, when you mark a thread as resolved, to make a post indicating how it was resolved, so as to aid future searchers.
Customary practice here on DSXchange is, when you mark a thread as resolved, to make a post indicating how it was resolved, so as to aid future searchers.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
I have sent out a private message to sivajoy,hope i would get quick reply.But if someone else meanwhile can give me some help it would be appreciated.
Suggestion:If somekind of process was in place having to move a topic to "Resolved" Status only if a solution was stated in the thread,might have been a really helpfull to all.
Suggestion:If somekind of process was in place having to move a topic to "Resolved" Status only if a solution was stated in the thread,might have been a really helpfull to all.
Good comes to those who seldom wish for it.
Found a solution [:D]
In Teradata Enterprise Stage,addional details should be given under Additional Connection Options as "SessionsPerPlayer= <Depends upon your requirement,i have it as 2> ,RequestedSessions = <Depends upon your requirement,i have it as 4> ,WORKDB = <LOG DB Name>" under the DB Options Mode.
In Teradata Enterprise Stage,addional details should be given under Additional Connection Options as "SessionsPerPlayer= <Depends upon your requirement,i have it as 2> ,RequestedSessions = <Depends upon your requirement,i have it as 4> ,WORKDB = <LOG DB Name>" under the DB Options Mode.
Good comes to those who seldom wish for it.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: