localuv db not able to fetch data

[vinsashi]

Hi,
have created two projects on same server.in one project in job can able to fetch data from univese database (localuv) from ds_jobs&ds_jobobjects.but in another project i couldnt able to fetch data please help on this.

Thanks

[ray.wurlod]

What's different?

Note: "nothing" is not the correct answer.

What error message(s) do you get in the second project?

Help us to help you.

[vinsashi]

have created two projects proj1 and proj2 on same server.imported prod dsx to both projects both projects sychronized.

i have created new job to get list of jobs in project.So created new job in proj1.

source query:
SELECT DS_JOBS.CATEGORY,DS_JOBS.NAME AS JOB_NAME
FROM DS_JOBS

universaldatabasestage(dsn-localuv)--transformer-seqfile

This job excuted in proj1.i am getting data.

but in the proj2 same job imported and excuted there is no data.

Please help on this

[ray.wurlod]

Is there an entry for localuv in the uvodbc.config file in each project?

Can you import the table definition for UniVerse table EXAMPLE1 in each project?

[vinsashi]

in both projects having same entry in uvodbc.config file.
and imported table definition example1 from each project but still not able to fetch data from proj2.

Thanks!!

[ray.wurlod]

Where exactly is the problem?
Can you View Data using the UniVerse stage?
Are there any errors or warnings in the job log?

[vinsashi]

At universe stage if i view it showing empty source.if i run job running successfully but no rows

Thanks

[ray.wurlod]

Then maybe the query genuinely returns 0 rows. Try executing the query using the Administrator client Command window.