Forum Stats

  • 3,814,174 Users
  • 2,258,834 Discussions
  • 7,892,602 Comments

Discussions

Data Service Generator Error: SnpPschema does not exist

449299
449299 Member Posts: 109
edited Jun 17, 2008 6:45PM in Data Integrator
I'm trying to setup a data service and I'm getting the following error when I try to generate the service. Thanks in advance:

com.sunopsis.tools.core.exception.SnpsRuntimeException: com.sunopsis.core.SnpsInexistantObjectException: SnpPschemaCont.getObjectByIdent : SnpPschema does not exist
at com.sunopsis.dwg.dataservices.AbstractWSGenerator.k(AbstractWSGenerator.java)
at com.sunopsis.dwg.dataservices.AbstractWSGenerator.a(AbstractWSGenerator.java)
at com.sunopsis.dwg.dataservices.WSGenerationTask.a(WSGenerationTask.java)
at com.sunopsis.graphical.i.c.b(c.java)
at com.sunopsis.graphical.tools.utils.swingworker.v.call(v.java)
at edu.emory.mathcs.backport.java.util.concurrent.FutureTask.run(FutureTask.java:176)
at com.sunopsis.graphical.tools.utils.swingworker.l.run(l.java)
at edu.emory.mathcs.backport.java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:665)
at edu.emory.mathcs.backport.java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:690)
at java.lang.Thread.run(Thread.java:595)
Caused by: com.sunopsis.core.SnpsInexistantObjectException: SnpPschemaCont.getObjectByIdent : SnpPschema does not exist
at com.sunopsis.dwg.dbobj.SnpPschema.getObjectByLSchemaNameAndContext(SnpPschema.java)
at com.sunopsis.dwg.dbobj.SnpPschema.getSnpPSchemaCont(SnpPschema.java)
at com.sunopsis.dwg.snpreference.c.a(c.java)
at com.sunopsis.dwg.snpreference.c.a(c.java)
at com.sunopsis.dwg.snpreference.c.<init>(c.java)
at com.sunopsis.dwg.codeinterpretor.g.a(g.java)
... 10 more
Caused by:
com.sunopsis.core.SnpsInexistantObjectException: SnpPschemaCont.getObjectByIdent : SnpPschema does not exist
at com.sunopsis.dwg.dbobj.SnpPschema.getObjectByLSchemaNameAndContext(SnpPschema.java)
at com.sunopsis.dwg.dbobj.SnpPschema.getSnpPSchemaCont(SnpPschema.java)
at com.sunopsis.dwg.snpreference.c.a(c.java)
at com.sunopsis.dwg.snpreference.c.a(c.java)
at com.sunopsis.dwg.snpreference.c.<init>(c.java)
at com.sunopsis.dwg.codeinterpretor.g.a(g.java)
at com.sunopsis.dwg.dataservices.AbstractWSGenerator.k(AbstractWSGenerator.java)
at com.sunopsis.dwg.dataservices.AbstractWSGenerator.a(AbstractWSGenerator.java)
at com.sunopsis.dwg.dataservices.WSGenerationTask.a(WSGenerationTask.java)
at com.sunopsis.graphical.i.c.b(c.java)
at com.sunopsis.graphical.tools.utils.swingworker.v.call(v.java)
at edu.emory.mathcs.backport.java.util.concurrent.FutureTask.run(FutureTask.java:176)
at com.sunopsis.graphical.tools.utils.swingworker.l.run(l.java)
at edu.emory.mathcs.backport.java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:665)
at edu.emory.mathcs.backport.java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:690)
at java.lang.Thread.run(Thread.java:595)

Comments

  • Hi,

    There is an issue with your Topology settings, ODI is not able to identify the physical schema (SNP_PSCHEMA stores the physical schemas) used by the datastore.
    Are you able to view the data of this datastore? It could also be a context issue, make sure that the physical/logical schemas in the context you pick while generating the dataservice are correctly defined.

    Thanks,
    Julien
This discussion has been closed.