Hi,
I'm having a problem in saving my jobs. when ever i try to save a job which uses a particular table as input source(IN SQL SERVER 2000 USING ODBC STAGE) It gives me an error message which is given below.
Error calling subroutine: DSR_RECORD (Action=2); check DataStage is set up correctly in project Development
(Internal Error (81021)).
I've tried recreating the table with a different name, and then referring that table in my job.But the problem persists.
CAN ANYBODY HELP ME IN THIS REGARD.
thanks
Dhiraj
Help! Help! Help!
Moderators: chulett, rschirm, roy
Are you saying that the act of saving a job is generating this message? How about saving other jobs, do you have the same problem?
Why do you mention the ODBC stage as the problem? Does the job save fine up until you add an ODBC stage? I'm confused as to where your problem begins.
Why do you mention the ODBC stage as the problem? Does the job save fine up until you add an ODBC stage? I'm confused as to where your problem begins.
Kenneth Bland
Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle
Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle
yes, this message is generated when i try saving my job.I don't have any problems while saving other jobs.
I mentioned ODBC because the job works fine until i refer to a particular table ,say "a"using an odbc stage.when i refer to any other table(apart from table "a") using the ODBC it works fine.I've also tried recreating the table in the database with a different name, but problem persists.
I mentioned ODBC because the job works fine until i refer to a particular table ,say "a"using an odbc stage.when i refer to any other table(apart from table "a") using the ODBC it works fine.I've also tried recreating the table in the database with a different name, but problem persists.
kcbland wrote:Are you saying that the act of saving a job is generating this message? How about saving other jobs, do you have the same problem?
Why do you mention the ODBC stage as the problem? Does the job save fine up until you add an ODBC stage? I'm confused as to where your problem begins.
Hi,
it sounds to me that trying to view thru that ODBC source some how disconnects your client for some reason.
I think in version 7 you can from the same crashed designer relogin to the project and have all the info intact or was it 7.0.1.
a dissconnected designer some times gives an error like what you got.
IHTH,
it sounds to me that trying to view thru that ODBC source some how disconnects your client for some reason.
I think in version 7 you can from the same crashed designer relogin to the project and have all the info intact or was it 7.0.1.
a dissconnected designer some times gives an error like what you got.
IHTH,
Roy R.
Time is money but when you don't have money time is all you can afford.
Search before posting:)
Join the DataStagers team effort at:
http://www.worldcommunitygrid.org
![Image](http://www.worldcommunitygrid.org/images/logo.gif)
Time is money but when you don't have money time is all you can afford.
Search before posting:)
Join the DataStagers team effort at:
http://www.worldcommunitygrid.org
![Image](http://www.worldcommunitygrid.org/images/logo.gif)
I didn't have this problem while saving a job rather while trying to view data from a OCI9 stage. The problem was a column defined as varchar was attempting to map to a CLOB field in Oracle. Sounds completely different then your case but my point is to suggest that you verify that you have no "exotic" column definitions in your job and that they are mapped correctly. The solution in my case was to change the varchar to a longvarchar. I guess DS 7.0.1 is a bit cranky when you mis-map the fields and decides to terminate with extreme prejudice the client session when it feels you are programming badly.
-
- Participant
- Posts: 90
- Joined: Mon Dec 08, 2003 4:48 am
- Location: Chennai
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: