Trying to Connect to Universe database - FAILED
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 298
- Joined: Tue Aug 26, 2008 12:17 pm
Trying to Connect to Universe database - FAILED
Hi everybody.
I am trying to execute a Query at theUniverse Database but the following message returns:
ReportJobCategory..DS_JOBS (OpenPath failed for - /opt/IBM/InformationServer/Server/branded_odbc):
ReportJobCategory..DS_JOBS.lnk_DS_JOBS: DSD.BCIOpenR call to function OCONV failed.
When the query is executed on Administrator (Command), the result is ok, but through ODBC stage this error is shown.
Query:
SELECT JOBNO, CATEGORY, NAME FROM DS_JOBS WHERE TRIM(JOBNO) <> '' AND TRIM(CATEGORY) <> '' ORDER BY CATEGORY, NAME, JOBNO;
What can it be?
Thanks, guys!!
Best Regards.
I am trying to execute a Query at theUniverse Database but the following message returns:
ReportJobCategory..DS_JOBS (OpenPath failed for - /opt/IBM/InformationServer/Server/branded_odbc):
ReportJobCategory..DS_JOBS.lnk_DS_JOBS: DSD.BCIOpenR call to function OCONV failed.
When the query is executed on Administrator (Command), the result is ok, but through ODBC stage this error is shown.
Query:
SELECT JOBNO, CATEGORY, NAME FROM DS_JOBS WHERE TRIM(JOBNO) <> '' AND TRIM(CATEGORY) <> '' ORDER BY CATEGORY, NAME, JOBNO;
What can it be?
Thanks, guys!!
Best Regards.
Joyce A. Recacho
São Paulo/SP
Brazil
São Paulo/SP
Brazil
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 298
- Joined: Tue Aug 26, 2008 12:17 pm
Hi my friend.chulett wrote:Have you considered using a Server job with the UV stage? ...
Let me correct something.
Actually I am punctually working in a project wich they use server jobs. I forgot to mention this important point.
The thing is:
We have tested and both ODBC stage and universe stage return this error.
When we run a job that uses an Oracle stage, it runs ok. No warnings and right result.
Do you know what it can be?
I am talking about version 8.5 Enterprise Edition, but a server job.
Thanks anyway!!
Joyce A. Recacho
São Paulo/SP
Brazil
São Paulo/SP
Brazil
The UV stage wouldn't return that error as far as I know. What happens if you use the UV stage as a source and select "localuv" as the data source? I don't recall if you can select that from a list or if you have to type it in but it should work just fine.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
-
- Participant
- Posts: 298
- Joined: Tue Aug 26, 2008 12:17 pm
Chulett,
That's exactly what I have done.
Actually it is a very simple job where there is a universe stage as the source and its result goes to a sequential file.
The query is that one I mentioned above.
I've already changed the uvodbc.config letting that one wich was created during the instalation process (the default one) and the problem still happens.
I don't know which configuration could solve this.
Thank uuuu
That's exactly what I have done.
Actually it is a very simple job where there is a universe stage as the source and its result goes to a sequential file.
The query is that one I mentioned above.
I've already changed the uvodbc.config letting that one wich was created during the instalation process (the default one) and the problem still happens.
I don't know which configuration could solve this.
Thank uuuu
Joyce A. Recacho
São Paulo/SP
Brazil
São Paulo/SP
Brazil
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Make sure that this entry appears in the project's uvodbc.config file.
In your UniVerse stage, specify localuv as the DSN.
Code: Select all
<localuv>
DBMSTYPE = UNIVERSE
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: 298
- Joined: Tue Aug 26, 2008 12:17 pm
-
- Participant
- Posts: 298
- Joined: Tue Aug 26, 2008 12:17 pm
So... how in the heck did you end up with DOS delimiters in your file? Are you transferring them to a PC for editing and then transferring them back rather than editing them directly on the UNIX server? If so, you needs to learn yourself some vi. ![Wink :wink:](./images/smilies/icon_wink.gif)
![Wink :wink:](./images/smilies/icon_wink.gif)
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers