0 Replies Latest reply: Jun 13, 2011 5:37 AM by user516875 RSS

    Problem Creating a new Publication Item

    user516875
      Hi,

      I'm trying to create a Publication Item (using ConsAPI) in a development environment but every time I'm doing it I get an exception. The publication item is created but when I try to add it to a Publication it gives me an error of Primary Key not found (the table has a pk).

      I've checked the permissions from the mobileadmin schema I can query the table without problems and I have full access (creation of objects as well), but the error you can see from the Oracle DB is "Table or View not found" (in German)


      When I create the same pub item and pub in my development environment everything works perfectly. The only difference is the Oracle DB (the partner is working on 10.2) version cause the Mobile Server is in both cases using 10.3.0.3 with the latest patchset.

      ¿Any idea? ¿Maybe it's a problem with the Oracle release?


      C:\workspace\AntBuilder_MobileSync>ant -f build_lite.xml createPublicationItem
      Buildfile: C:\workspace\AntBuilder_MobileSync\build_lite.xml

      createPublicationItem:
      [create_PI] Project org.apache.tools.ant.Project@1e4cbc4
      [create_PI] mobileadmin
      [create_PI] Connecting To The Mobile Repository
      [create_PI] Connected To The Mobile Repository
      [create_PI] Creating Publication Item customer_pi from menvadis_swsls_man1.custo
      mer_updatable
      [create_PI] Unable To Create Publication Items.
      [create_PI] oracle.lite.sync.ConsolidatorException:
      [create_PI]
      [create_PI] CONS-10049: Consolidator Exception: Tabelle oder View nicht gefunden
      ::menvadis_swsls_man1.customer_updatable
      [create_PI]
      [create_PI] at oracle.lite.sync.Subscription.getConsolidatorExceptionAndRoll
      back(Subscription.java:14416)
      [create_PI] at oracle.lite.sync.ConsolidatorManager.createPublicationItem(Co
      nsolidatorManager.java:1319)
      [create_PI] at CreatePublicationItemTask.createPublicationItem(Unknown Sourc
      e)
      [create_PI] at CreatePublicationItemTask.execute(Unknown Source)
      [create_PI] at org.apache.tools.ant.UnknownElement.execute(UnknownElement.ja
      va:291)
      [create_PI] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      [create_PI] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAcces
      sorImpl.java:39)
      [create_PI] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMet
      hodAccessorImpl.java:25)
      [create_PI] at java.lang.reflect.Method.invoke(Method.java:597)
      [create_PI] at org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchU
      tils.java:106)
      [create_PI] at org.apache.tools.ant.Task.perform(Task.java:348)
      [create_PI] at org.apache.tools.ant.Target.execute(Target.java:390)
      [create_PI] at org.apache.tools.ant.Target.performTasks(Target.java:411)
      [create_PI] at org.apache.tools.ant.Project.executeSortedTargets(Project.jav
      a:1399)
      [create_PI] at org.apache.tools.ant.Project.executeTarget(Project.java:1368)

      [create_PI] at org.apache.tools.ant.helper.DefaultExecutor.executeTargets(De
      faultExecutor.java:41)
      [create_PI] at org.apache.tools.ant.Project.executeTargets(Project.java:1251
      )
      [create_PI] at org.apache.tools.ant.Main.runBuild(Main.java:809)
      [create_PI] at org.apache.tools.ant.Main.startAnt(Main.java:217)
      [create_PI] at org.apache.tools.ant.launch.Launcher.run(Launcher.java:280)
      [create_PI] at org.apache.tools.ant.launch.Launcher.main(Launcher.java:109)
      [create_PI] Closing Connection To Mobile Repository
      [create_PI] Connection To Mobile Repository Closed




      tal time: 2 seconds

      C:\workspace\AntBuilder_MobileSync>ant -f build_lite.xml createPublication
      Buildfile: C:\workspace\AntBuilder_MobileSync\build_lite.xml

      createPublication:
      [create_PB] Project org.apache.tools.ant.Project@1e4cbc4
      [create_PB] mobileadmin
      [create_PB] Connecting To The Mobile Repository
      [create_PB] Connected To The Mobile Repository
      [create_PB] Creating Publication customer_pub
      [create_PB] nameOfPublication Publication Created
      [create_PB] Closing Connection To Mobile Repository
      [create_PB] Connection To Mobile Repository Closed

      BUILD SUCCESSFUL
      Total time: 2 seconds

      C:\workspace\AntBuilder_MobileSync>ant -f build_lite.xml addPublicationItem
      Buildfile: C:\workspace\AntBuilder_MobileSync\build_lite.xml

      addPublicationItem:
      [add_PI] Project org.apache.tools.ant.Project@1e4cbc4
      [add_PI] mobileadmin
      [add_PI] Connecting To The Mobile Repository
      [add_PI] Connected To The Mobile Repository
      [add_PI] Adding Publication Item customer_pi to Publication customer_pub
      [add_PI] Unable To Add Publication Items To Publication customer_pub
      [add_PI] oracle.lite.sync.ConsolidatorException:
      [add_PI]
      [add_PI] CONS-10032: Publikationselement: CUSTOMER_PI kann nicht aktualisiert
      werden, Primõrschl³ssel f³r menvadis_swsls_man1.customer_updatable nicht gefund
      en
      [add_PI]
      [add_PI] at oracle.lite.sync.Subscription.CreatePublicationMapInQueue(Sub
      scription.java:5169)
      [add_PI] at oracle.lite.sync.Subscription.AddPublicationItem(Subscription
      .java:4923)
      [add_PI] at oracle.lite.sync.ConsolidatorManager.addPublicationItem(Conso
      lidatorManager.java:2406)
      [add_PI] at oracle.lite.sync.ConsolidatorManager.addPublicationItem(Conso
      lidatorManager.java:2183)
      [add_PI] at AddPublicationItemTask.addPublicationItem(Unknown Source)
      [add_PI] at AddPublicationItemTask.execute(Unknown Source)
      [add_PI] at org.apache.tools.ant.UnknownElement.execute(UnknownElement.ja
      va:291)
      [add_PI] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      [add_PI] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAcces
      sorImpl.java:39)
      [add_PI] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMet
      hodAccessorImpl.java:25)
      [add_PI] at java.lang.reflect.Method.invoke(Method.java:597)
      [add_PI] at org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchU
      tils.java:106)
      [add_PI] at org.apache.tools.ant.Task.perform(Task.java:348)
      [add_PI] at org.apache.tools.ant.Target.execute(Target.java:390)
      [add_PI] at org.apache.tools.ant.Target.performTasks(Target.java:411)
      [add_PI] at org.apache.tools.ant.Project.executeSortedTargets(Project.jav
      a:1399)
      [add_PI] at org.apache.tools.ant.Project.executeTarget(Project.java:1368)

      [add_PI] at org.apache.tools.ant.helper.DefaultExecutor.executeTargets(De
      faultExecutor.java:41)
      [add_PI] at org.apache.tools.ant.Project.executeTargets(Project.java:1251
      )
      [add_PI] at org.apache.tools.ant.Main.runBuild(Main.java:809)
      [add_PI] at org.apache.tools.ant.Main.startAnt(Main.java:217)
      [add_PI] at org.apache.tools.ant.launch.Launcher.run(Launcher.java:280)
      [add_PI] at org.apache.tools.ant.launch.Launcher.main(Launcher.java:109)
      [add_PI] Closing Connection To Mobile Repository
      [add_PI] Connection To Mobile Repository Closed

      BUILD SUCCESSFUL
      Total time: 2 seconds