[OFBiz] Users - POS: pos_terminal_state vs. pos_state_pos

[Gordon B Lugauer]

Ok, you all must be getting sick of me, because even *I* am starting
to get sick of me.

Now, java -jar ofbiz.jar -pos runs.  The glorious POS screen
appears, and it even looks like it does with the demo data.
I create a userid/password for the admin user so I can log in.
Life seems so promising.

Then, when I try to open the terminal, the following error appears
(ok, in the midst of a whole bunch of other ugliness, but this
seems the salient part):

ERROR: insert or update on table "pos_terminal_state" violates foreign key constraint "pos_state_pos"

Seems like a disagreement in the schema somewhere, but I can't seem
to find out where to smooth it out.

Pointers?

Thanks much,

--
-Gordon B Lugauer

BadgerClaw, llc
All things Unix         All things IP
[hidden email] e          414-273-6666 v          262-364-2929 f
 
_______________________________________________
Users mailing list
[hidden email]
http://lists.ofbiz.org/mailman/listinfo/users

[Gordon B Lugauer]

A more complete error snippet would probably be more useful:

org.ofbiz.entity.GenericEntityException: while inserting: [GenericEntity:PosTerminalState][createdStamp,2005-11-10 01:30:05.091(java.sql.Timestamp)][createdTxStamp,2005-11-10 01:30:05.089(java.sql.Timestamp)][lastUpdatedStamp,2005-11-10 01:30:05.091(java.sql.Timestamp)][lastUpdatedTxStamp,2005-11-10 01:30:05.089(java.sql.Timestamp)][openedByUserLoginId,12345(java.lang.String)][openedDate,2005-11-10 01:30:05.088(java.sql.Timestamp)][posTerminalId,pos-1(java.lang.String)][startingDrawerAmount,1.0(java.lang.Double)][startingTxId,10010(java.lang.String)] (SQL Exception while executing the following:INSERT INTO public.POS_TERMINAL_STATE (POS_TERMINAL_ID, OPENED_DATE, CLOSED_DATE, STARTING_TX_ID, ENDING_TX_ID, OPENED_BY_USER_LOGIN_ID, CLOSED_BY_USER_LOGIN_ID, STARTING_DRAWER_AMOUNT, ACTUAL_ENDING_CASH, ACTUAL_ENDING_CHECK, ACTUAL_ENDING_CC, ACTUAL_ENDING_GC, ACTUAL_ENDING_OTHER, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?!
, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (ERROR: insert or update on table "pos_terminal_state" violates foreign key constraint "pos_state_pos"))
org.ofbiz.entity.datasource.GenericDAO.singleInsert(GenericDAO.java:195)
org.ofbiz.entity.datasource.GenericDAO.insert(GenericDAO.java:137)
org.ofbiz.entity.datasource.GenericHelperDAO.create(GenericHelperDAO.java:75)
org.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:582)
org.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:555)
org.ofbiz.entity.GenericValue.create(GenericValue.java:121)
org.ofbiz.pos.event.ManagerEvents.openTerminal(ManagerEvents.java:138)
org.ofbiz.pos.event.MenuEvents.triggerEnter(MenuEvents.java:97)
sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
java.lang.reflect.Method.invoke(Method.java:324)
org.ofbiz.pos.config.ButtonEventConfig.invoke(ButtonEventConfig.java:217)
org.ofbiz.pos.config.ButtonEventConfig.invokeButtonEvent(ButtonEventConfig.java:117)
org.ofbiz.pos.component.PosButton$1.construct(PosButton.java:132)
net.xoetrope.xui.helper.SwingWorker$2.run(Unknown Source)
java.lang.Thread.run(Thread.java:534)
org.ofbiz.entity.GenericDataSourceException: SQL Exception while executing the following:INSERT INTO public.POS_TERMINAL_STATE (POS_TERMINAL_ID, OPENED_DATE, CLOSED_DATE, STARTING_TX_ID, ENDING_TX_ID, OPENED_BY_USER_LOGIN_ID, CLOSED_BY_USER_LOGIN_ID, STARTING_DRAWER_AMOUNT, ACTUAL_ENDING_CASH, ACTUAL_ENDING_CHECK, ACTUAL_ENDING_CC, ACTUAL_ENDING_GC, ACTUAL_ENDING_OTHER, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (ERROR: insert or update on table "pos_terminal_state" violates foreign key constraint "pos_state_pos")


Once upon a time (Thu, Nov 10, 2005 at 01:26:21AM -0600 to be precise),
the illustrious Gordon B Lugauer said:

> Ok, you all must be getting sick of me, because even *I* am starting
> to get sick of me.
>
> Now, java -jar ofbiz.jar -pos runs.  The glorious POS screen
> appears, and it even looks like it does with the demo data.
> I create a userid/password for the admin user so I can log in.
> Life seems so promising.
>
> Then, when I try to open the terminal, the following error appears
> (ok, in the midst of a whole bunch of other ugliness, but this
> seems the salient part):
>
> ERROR: insert or update on table "pos_terminal_state" violates foreign key constraint "pos_state_pos"
>
> Seems like a disagreement in the schema somewhere, but I can't seem
> to find out where to smooth it out.
>
> Pointers?
>
> Thanks much,
>
> --
> -Gordon B Lugauer
>
> BadgerClaw, llc
> All things Unix         All things IP
> [hidden email] e          414-273-6666 v          262-364-2929 f

 
_______________________________________________
Users mailing list
[hidden email]
http://lists.ofbiz.org/mailman/listinfo/users