Chapter 10. Transaction Manager Error Messages

General error. The START command was issued without a transaction name or a bad value was specified for the return code of an event function.

n/a

Standard JPL error; generally indicates the JPL procedure or variable causing the error. One cause which is not a syntax error is using the property API to query for the value of server view, table view or link when it is not in the current traversal tree or for the value of num_key_columns when a database modification command is not in effect.

Edit the JPL procedure.

Command availability varies according to the transaction mode.

1. Refer to "Setting the Transaction Mode" in Application Development Guide for the command availability in each mode.

2. Use the COPY_FOR_UPDATE and COPY_FOR_VIEW commands, which set the mode, when appropriate.

3. For menu items and push buttons, set the class property which controls the active/inactive property according to the transaction mode.

1. Invalid column name specified in the link's Relations property.

2. Parent and Child entries for the Relations need to be reversed.

Edit the relations property to contain the column names which join the two table views named in the link. Check that column names exist in the corresponding Parent and Child table views.

Transaction manger command was executed without saving the changes made to onscreen data.

Choose Yes to discard changes; choose No to return to the screen so that the SAVE command can be executed.

Transaction manger command was executed without saving the changes made to a portion of onscreen data.

Choose Yes to discard changes; choose No to return to the screen so that the SAVE command can be executed.

Error occurred while executing a command in one of Panther's database drivers.

Refer to error for action.

This error lists whether a model or function is being accessed, the name of the model or function, and the event that failed. One common usage is to display the failed event after an error has been reported from the database engine.

Generally, the engine error is more descriptive of the problem

Version columns must have the C Type property set to Int, Long, Float or Double.

Change C Type property. As a result, database re-design might be necessary.

Value entered for the sort type is invalid.

Change the sort order type to ASC or DESC.

The Sort Widgets property does not contain a valid widget name.

Check the table view's sort_widgets property and make sure the widget is on the screen; it is the widget name and not the database column name that must be specified.

1. Transaction event function specified in Function property is defined without passing it the event argument.

2. Transaction event function has incorrect or invalid return code specified, for example, TM_CHECK instead of TM_PROCEED when no database driver statement was issued for that event.

For 1, add (event) after the procedure name.

For 2, change return code.

1) There is a circular link in the Parent and Child properties.

2) A link has both the Parent and Child properties set to the same table view.

Check parent and child properties for each link, editing where necessary.

Command availability varies according to the transaction mode

1. Refer to "Setting the Transaction Mode" in Application Development Guide for the command availability in each mode.

2. Use the COPY_FOR_UPDATE and COPY_FOR_VIEW commands, which set the mode, when appropriate.

3. For menu items and push buttons, set the class property which controls the active/inactive property according to the transaction mode.

TM_CHECK_ONE_ROW, which calls the TM_TEST_ONE_ROW event to check that @dmrowcount is equal to 1, has been set as the return code either in the transaction model or in an event function.

Change the return code in the model or event function. Change the SQL generation, for example, by expanding the primary key values so that only one row is changed. Check data in the database to make sure that duplicate key values have not been entered.

TM_CHECK_SOME_ROWS, which calls the TM_TEST_SOME_ROWS event to check that @dmrowcount is equal to or greater than 1, has been set as the return code either in the transaction model or in a event function.

If error is valid, do nothing. Otherwise, change the return code in the model or event function.

For all the members of this table view, either the column_name property is blank or the use_in_select property is set to PV_NO.

Set the appropriate properties for each widget.

The syntax of sm_tm_command is incorrect.

Edit the call to sm_tm_command so that a valid command name is the first parameter of its quoted command string.

The syntax of sm_tm_command is incorrect.

Edit the call to sm_tm_command so that a valid scope parameter follows the command and table view parameters.

The syntax of sm_tm_command is incorrect.

Edit the call to sm_tm_command so that a valid table view name follows the command parameter in the quoted command string.

For commands that could result in database modifications, like SELECT, NEW, COPY, or COPY_FOR_UPDATE, the transaction manager checks that primary key fields for a table view are available.

Specify the table view's primary key in the primary_key property.

1. Table view parameter supplied with START command is not valid.

2. More than one table view appears on a screen and there are no link widgets.

For 1, edit START command specification.

For 2, create a link widget with the appropriate Parent, Child and Relations property settings.

Table property is blank for this table view.

Enter the name of the database table in the table view's Table property. For the format needed by a specific database driver, refer to "Database Drivers."

Table property is blank for this table view.

Enter the name of the database table in the table view's Table property. For the format needed by a specific database driver, refer to "Database Drivers."

For commands that could result in database modifications, like SELECT, NEW, COPY, or COPY_FOR_UPDATE, the primary key fields of an updatable table view must either be a member of that table view or one of its parent table views. It does not have to be in the direct parent, it can be in the "grandparent" table view.

1. Add the widget to the desired table view.

2. Check the link's relations property to see if the shared fields between the table views is complete.

3. Change the table view to non-updatable.

4. Check the link's relations property to make sure the relation type is valid.

sm_tm_command is being called recursively.

Do not call sm_tm_command in transaction manager event functions.

Model specified in table view or screen properties is not initialized.

Specify valid model or leave blank to use standard model.

1. Transaction manager command was called in an unnamed JPL procedure. Since Panther calls the unnamed JPL procedure before it calls the START command on screen entry, an error occurs.

2. More than one table view appears on a screen and there are no link widgets.

3. START command was not issued because of error in table view tree or because the table view parameter specified with the command was invalid.

For 1, call the command after the START command has been invoked, for example, in the screen entry procedure.

For 2, create a link widget with the appropriate Parent, Child and Relations property settings.

For 3, check Parent and Child properties. Check specification of additional START commands.

For all updatable table views, the transaction manager synchronizes the tableviews when a command that could modify data is issued, for example, SELECT, NEW, COPY, or COPY_FOR_UPDATE.

1. If possible, set all the members of the same table view whose use_in_update property is set to PV_YES to the same number of occurrences

2. Change the synchronization property to PV_NO.

The table view's Function property specifies a name that is not available either as a JPL procedure or as a prototyped function.

1. Check the value of the function property.

2. Check the prototyped function list.

3. Check that the JPL procedure name matches the function property and that the JPL module is available.

If a widget's version_column property is PV_YES, then the properties in_delete_where and in_update_where must be set to PV_NO.

Set the properties to the correct values