Error when trying to read from Oracle Enterprise Stage
Moderators: chulett, rschirm, roy
Error when trying to read from Oracle Enterprise Stage
Hello,
I am getting errors when trying to read from an Oracle Enterprise Stage. In the Output Propeties tab, I have to parameterize the table schema, the user and password, and the remote server. However, when I do paramterize these, I get errors saying it could not identify the schema, invalid logon, etc.
It seems to not be recognizing the parameters, as if there were no value in the parameter.
When I hardcode everything, it works. But even when I try to parameterize one of the values, it fails. Any suggestions?
Also, I have tried putting single quotes around the User parameter, and everything else hardcoded, and it still failed.
Thanks in advance.
I am getting errors when trying to read from an Oracle Enterprise Stage. In the Output Propeties tab, I have to parameterize the table schema, the user and password, and the remote server. However, when I do paramterize these, I get errors saying it could not identify the schema, invalid logon, etc.
It seems to not be recognizing the parameters, as if there were no value in the parameter.
When I hardcode everything, it works. But even when I try to parameterize one of the values, it fails. Any suggestions?
Also, I have tried putting single quotes around the User parameter, and everything else hardcoded, and it still failed.
Thanks in advance.
Jweir
--- If strength were all, tiger would not fear scorpion.
--- If strength were all, tiger would not fear scorpion.
-
- Participant
- Posts: 342
- Joined: Tue Nov 04, 2008 10:38 am
- Location: Chennai, India
-
- Participant
- Posts: 342
- Joined: Tue Nov 04, 2008 10:38 am
- Location: Chennai, India
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Please post the exact error message. If it has sharp signs (parameter references) in it, then the parameters are not being resolved correctly. Check that the references are correctly spelled and cased.
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.
When I put all the parameters in the stage, this is the error I recieve:
Also, I have checked with the parameter values, and they are correct.
As for the sharp signs, they are present when I enter them at the output properties tab.
Also, this Oraclt stage is inside a shared container, but I wouldn't think that is would affect it. But I could be wrong.scRetrieveAuditFields.ETL_JOBID_LIST: Incorrect dboption list; it failed on Expected value for property "user", got: ",", line 1
Expected value for property "password", got: "}", line 1.
Also, I have checked with the parameter values, and they are correct.
As for the sharp signs, they are present when I enter them at the output properties tab.
Jweir
--- If strength were all, tiger would not fear scorpion.
--- If strength were all, tiger would not fear scorpion.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
The error message is saying that there are no values for user and password:scRetrieveAuditFields.ETL_JOBID_LIST: Incorrect dboption list; it failed on Expected value for property "user", got: ",", line 1
Expected value for property "password", got: "}", line 1.
"user", got: ","
That is saying the parameters are not passing anything, because the DB Options are:"password", got: "}",
Like I said, when I hardcoded the same values I have in the environment variables, it works. But when I parameterize one value, it fails.{user=#USER_PARAMETER#,password=#PASSWORD_PARAM#}
Jweir
--- If strength were all, tiger would not fear scorpion.
--- If strength were all, tiger would not fear scorpion.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
That was just an example. Here is actual:
Code: Select all
{user=#GetPROJDEFValues.$stg_ETLJOB_ora_USER#,password=#GetPROJDEFValues.$stg_ETLJOB_ora_PASS#}
Jweir
--- If strength were all, tiger would not fear scorpion.
--- If strength were all, tiger would not fear scorpion.
-
- Participant
- Posts: 53
- Joined: Fri Apr 18, 2008 8:13 am
- Location: United States
Error when trying to read from Oracle Enterpise Stage
Hi,
In your Oracle source stage are you giving the parameter values which are defined in the Parameter section?
{user=#GetPROJDEFValues.$stg_ETLJOB_ora_USER#,password=#GetPROJDEFValues.$stg_ETLJOB_ora_PASS#}
"GetPROJDEFValues.$stg_ETLJOB_ora_USER" is the correct parameter value or "$stg_ETLJOB_ora_USER" is the actual parameter value?
In your Oracle source stage are you giving the parameter values which are defined in the Parameter section?
{user=#GetPROJDEFValues.$stg_ETLJOB_ora_USER#,password=#GetPROJDEFValues.$stg_ETLJOB_ora_PASS#}
"GetPROJDEFValues.$stg_ETLJOB_ora_USER" is the correct parameter value or "$stg_ETLJOB_ora_USER" is the actual parameter value?
Regards
Ajay
Ajay
Hello,
It was determined that there was something wrong the with shared container. I have it working now. We were missing some of the parameters in the shared container that were being used in the job, but not in the container itself. Does that matter that all the parameters that are being used in the job should be added to the container, even if they aren't being used?
It was determined that there was something wrong the with shared container. I have it working now. We were missing some of the parameters in the shared container that were being used in the job, but not in the container itself. Does that matter that all the parameters that are being used in the job should be added to the container, even if they aren't being used?
Jweir
--- If strength were all, tiger would not fear scorpion.
--- If strength were all, tiger would not fear scorpion.