Skip to Content
0
Former Member
May 06, 2009 at 08:25 PM

PI 7.1 JDBC Lookup error

17 Views

I have created a simple mapping program using JDBC Lookup function. I added the required entry in mapping signature.

I am able to select the DB fields coming in and going out of the function in the JDBC Lookup properties. I then join up the source and target fields to the JDBC lookup function.

When I try and save the map I get a pop up error:

Binding rec0 is not found in the brick. Check update method

Thrown:

com.sap.aii.utilxi.swing.framework.FrameworkException: Internal problem occurred

at com.sap.aii.utilxi.swing.toolkit.ExceptionDialog.init(ExceptionDialog.java:124)

at com.sap.aii.utilxi.swing.toolkit.ExceptionDialog.<init>(ExceptionDialog.java:96)

at com.sap.aii.utilxi.swing.toolkit.IBMessages$1.run(IBMessages.java:319)

at java.awt.event.InvocationEvent.dispatch(Unknown Source)

at java.awt.EventQueue.dispatchEvent(Unknown Source)

at com.sap.aii.utilxi.swing.toolkit.Guitilities$EventProcessor.dispatchEvent(Guitilities.java:319)

at java.awt.EventDispatchThread.pumpOneEventForHierarchy(Unknown Source)

at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source)

at java.awt.EventDispatchThread.pumpEvents(Unknown Source)

at java.awt.EventDispatchThread.pumpEvents(Unknown Source)

at java.awt.EventDispatchThread.run(Unknown Source)

Caused by: java.lang.IllegalStateException: Binding rec0 is not found in the brick. Check update method

at com.sap.aii.mappingtool.mf.functions.bind.GroupBinding.applyBindings(GroupBinding.java:55)

at com.sap.aii.mappingtool.mf.tvd.bricks.MacrosBrick.store(MacrosBrick.java:94)

at com.sap.aii.mappingtool.mf.tvd.PinOut.store(PinOut.java:43)

at com.sap.aii.mappingtool.mf.tvd.bricks.DestBrick.storeMappingTree(DestBrick.java:349)

at com.sap.aii.mappingtool.mf.tvd.bricks.DestBrick.store(DestBrick.java:168)

at com.sap.aii.mappingtool.mf.Transformation.buildStructure0(Transformation.java:97)

at com.sap.aii.mappingtool.mf.Transformation.storeNodesDeccendants(Transformation.java:178)

at com.sap.aii.mappingtool.mf.Transformation.buildStructure(Transformation.java:88)

at com.sap.aii.mappingtool.mf.Transformation.store(Transformation.java:70)

at com.sap.aii.mappingtool.Project.getJavaFile(Project.java:329)

at com.sap.aii.mappingtool.mf.MappingTool.getJavaFile(MappingTool.java:107)

at com.sap.aii.mappingtool.fwutil.api.DataAccessAbstract.getZippedSourceCode(DataAccessAbstract.java:597)

at com.sap.aii.mappingtool.fwutil.api.DataAccessAbstract.execute(DataAccessAbstract.java:152)

at com.sap.aii.mappingtool.mf.DAOProxy.execute(DAOProxy.java:58)

at com.sap.aii.mappingtool.dbg.model.MTQueuesRunner.runTransformation(MTQueuesRunner.java:59)

at com.sap.aii.mappingtool.test.ATestCaseRunner$1.run(ATestCaseRunner.java:128)