Error Log and Troubleshooting

How-To-Use

Use Ctrl+F to try to find the error message.

1 How-To-Use
2 Corrected by Support
3 Corrected by User
4 Corrected by Development
5 Corrected by IT
6 Related articles

Corrected by Support

Problem - Receiving error processing Undeposited Funds (UDF) Batch

Error text:

ORA-24381: error(s) in array DML

ORA-06512: at “ENTERPRISE.

BNK_REGISTER_DEP_DTL_TAPI”, line 7

ORA-06512 at “ENTERPRISE.BANK_REGISTRY”, line 71

ORA-06512: at “ENTERPRISE.UNDEPOSITED_BATCH”,

line 231

Solution

Put in a support ticket via Jira.

Problem - Customer Can’t Find Bank Transaction

Customer has transactions they aren’t seeing in undeposited funds or in the Bank Rec.

Solution

Put in a support ticket via Jira.

Problem - Customer Aging isn’t Matching Customer Account - Rounding Issue

$0 lines are printing on the Customer Aging, but the Customer Account is blank

Solution

Put in a support ticket via Jira.

Problem - Credit Memo Won’t Process Due to Error

Error text:

ORACLE error: unable to UPDATE record.

FRM-40509

ORA-01483: invalid length for DATE or NUMBER bind

variable

Solution

Put in a support ticket via Jira.

Problem - Receiving error that Report/Screen Doesn’t Exist

Error text:

KEY-PRINT trigger raised unhandled exception ORA-

04067.

FRM-40735

ORA-04067: not executed, stored procedure “PUBLIC.

ARV_SMAN_SUMMARY_RAPI” does not exist

Solution

Put in a support ticket via Jira.

Problem - Vouchers won’t Process due to Error

Error text:

Could Not Process Voucher: po_vouchers had error

when:

B4 Start

ORA-02291: integrity constraint (ENTERPRISE.

APY_PO_INV_PO_RECEIVE_KEY_FK) violated - parent

key not found

Solution

Put in a support ticket via Jira.

Problem - Item Quantity Available VS Qty On Hand

An item is showing No Qty Available in the F9 lookup or is saying there is none available to ship, even though it says there are quantity on hand.

Solution

Put in a support ticket via Jira.

Problem - Credit/Debit Applied Directly to Invoice by mistake

If a Credit or Debit is applied directly to an invoice, it will stop you from being able to reverse the Invoice. The connection can’t be removed on the user side

Solution

Put in a support ticket via Jira.

Problem - Adjustments Entered Incorrectly. Need to Reverse

Documents were applied to each other using Adjustments, but now they need to make a change that is blocked by the adjustment.

Solution

Put in a support ticket via Jira.

Problem - Error Cancelling PO / Line

Error message when Cancelling PO or PO line:

Cannot find the Order Details this PO is tied to. Please contact Support

Solution

Put in a support ticket via Jira.

Problem - Error Changing Item Number

Receiving this error trying to change item number:

Exception updating_trx_items, table: ORD_DETAIL_INPUT

UPDATE ENTERPRISE.ORD_DETAIL_INPUT SET Item_key =

95200, item = INV_CHG_PACK.GET_NEW_CHG_ITEM WHERE

ITEM_KEY = 95200

ORA-01407: cannot update (“ENTERPRISE”,”

ORD_DETAIL_INPUT”.”ITEM_KEY”) to NULL

Solution

Put in a support ticket via Jira.

Problem - Import JSON File Saying Duplicate Line When there Isn’t

Receiving this error trying to import an Order/Project. Seems unique to instance, as file imports in QA fine.

AQ File has Duplicate AQ Line Numbers

Please check/edit your File in AQ

Solution

Put in a support ticket via Jira.

Problem - Order Query Error, Items not Loading

Receiving this error trying to open an Order. Some of the items aren’t loading

Post-Query on Order Detail

Populate Item Description

ORA-01403: no data found

Solution

Put in a support ticket via Jira.

Problem - Can’t Print Pick Tickets

Receiving this error trying to print Pick Tickets:

ORA-06502: PL/SQL: numeric or value error

Debug log error:

"ORA-01422: exact fetch returns more than requested number of rows
" "ERROR: Could not create pick ticket: ORA-01422: exact fetch returns more than requested number of rows
ORA-06512: at "ENTERPRISE.ORD_PICK_PACK", line 1667
ORA-06512: at "ENTERPRISE.ORD_PICK_PACK", line 412
ORA-06512: at "ENTERPRISE.ORD_PICK_PACK", line 810
"

Solution

Put in a support ticket via Jira.

Problem - Can’t Add Item to POS Order

Receiving this error trying to print Add item to POS Order:

Unhandled validation error: ORA-01422: exact fetch returns more than requested number of rows

ORA-06512: at “ENTERPRISE.TRX_CALCS”,line 971

ORA-06512: at “ENTERPRISE.TRX_CALCS”,line 994

ORA-06512: at “ENTERPRISE.POS_VALIDATION_PACK”,line 1680

Solution

Put in a support ticket via Jira.

Problem - Can’t Process Batch in Undeposited Funds

Receiving this error trying to process a UDF Batch:

ORA-06502: PL/SQL: numeric or value error: character

string buffer too small

ORA-06512: at “ENTERPRISE.

BNK_UNDEPOSITED_BATCH_DTL_TAPI”, line 50

ORA-06512: at “ENTERPRISE.BANK_REGISTRY”, line 63

ORA-06

Solution

Put in a support ticket via Jira.

Problem - Quote Add Item Error

Receive a Unique Constraint and KEY-NEXT-ITEM errors when adding an item to a quote

ORA-00001: unique constraing (Enterprise.

QES_QUOTE_DETAIL_IN) violated

ORA-06512: at “ENTERPRISE.QES_QUOTE_DETAIL_TAPI”, line 181

KEY-NEXT-ITEM trigger raised unhandled exception ORA-

FRM-40735

ORA-01403: no data found

Solution

Put in a support ticket via Jira.

Problem - Project Invoice AVATAX Error

Users with Avatax are receiving errors when trying to process project Invoices.

"ORA-06510: PL/SQL: unhandled user-defined exception
ORA-06510: PL/SQL: unhandled user-defined exception
ORA-06512: at "ENTERPRISE.AVATAX_PACK", line 3303
ORA-01461: can bind a LONG value only for insert into a LONG column
" "DOC(1521432): Customer 34855
ORA-01461: can bind a LONG value only for insert into a LONG column when Completing JSON body"

"ORA-06510: PL/SQL: unhandled user-defined exception
" "Error Creating Invoice!
DOC(66799): Customer 23781
ORA-01461: can bind a LONG value only for insert into a LONG column when Completing JSON body order number/key =65113/8827785
DOC(66799): Customer 23781
ORA-01461: can bind a LONG value only for insert into a LONG column when Completing JSON body"

Solution

Put in a support ticket via Jira.

Corrected by User

Problem - Can’t Open Saved Document in Document Management

Receiving this error trying to open saved document:

Windows cannot find ‘\C:\Users\[File location]’. Make sure you typed the name correctly, and then try again

Solution

This is a Java issue that comes up periodically. You will need to make sure you are on the latest version. If that still gives you issues, then you will need to revert to the version before.

Here are instructions: TRX Java version Issue”

Attempt to use the instructional guide and if problems persist submit a support ticket via Jira.

Problem - Project Return Ticket Entry Error

Receiving this error trying to enter a return ticket

SELECT ROWID,CO,PRJ_RETURN_KEY,PRJ_RETURN_NUMBER,RETURN_STATUS,TRANS_DATE,COMMENTS,CREATED_BY,CREATED_TIME_STAMP,PRJ_KEY,RETURN_DATE,SHIP_VIA,BURDEN_TYPE,BURDEN_AMT,PRINT_PRICES,TASK_KEY,WIP_CHART_KEY,SHIP_TO_ADDRESS FROM pja_return_master WHERE prj_return_key = and (CO=:1)

ORA-00936: missing Expression

Solution

There is a Return Ticket record stuck behind the scenes. Manually enter a return for the Project, and it should clear.

Attempt solution provided or put in a support ticket via Jira.

Problem - Can’t Print Pick Tickets

Error message when Printing Pick Tickets

There are no picking tickets matching this criteria

The following users are running tickets: ENTERPRISE

Solution

Print Tickets are being printed by a user, and they did not select Yes or No when prompted.

The user needs to exit that screen

If the above solution doesn’t work, put in a support ticket via Jira.

Problem - AQ API Price Update Error

Error text:

ORA-01001: invalid cursor

ORA-06512: at “AQ.

PRODUCTS_API_COORDINATOR, line 1032

ORA-24381: error(s) in array DML

Solution

There are duplicate UOM records for items on this manufacturer. You need to run the Rebuild Xref button on the Product Console to correct. You may need to resync under the Manufacturer first, if this gives you an error.

Attempt the solution provided, if issues continue put in a support ticket via Jira

Problem - Report Shows a Salesperson List is Activated

Report is showing a Salesperson List is Activated, even though the user didn’t select one. It won’t go away no matter what they try.

Solution

This is the salesperson List function set at the User level (SYS>User Setup). They will need to clear the field or uncheck the “Lock List” button to allow them to change it.

Attempt the solution listed and if problems persist put in a support ticket via Jira.

Problem - Can’t Save Changes to PO because of an Error

Receiving this error when trying to save PO

SYSMAN is holding a lock against this record, please try

again later

Solution

Guide: Deadlocks - Slow Speed, Stalling, Locked-up

Enterprise user may use this guide for the solution. If unavailable put in a support ticket via Jira.

Problem - Item Not showing in Daily Work

Item is Allocated and on BO, but it isn’t showing up in Daily Work to be Ordered for their Vendor.

Solution

The Item’s Vendor record likely has an invalid UOM set as the Purchase UOM. You will need to either add this UOM to the Item so it is valid, or you can change the Purchase UOM to an existing UOM.

Corrected by User creating the UOM or changing Vendor UOM to a valid one. If problem persists, put in a support ticket via Jira.

Problem - Error Exporting Report

Receiving this error trying to Export report:

WUT-105: Unable to open file

S:\Accounting\apy_check_register-20220909.csv for

writing

Solution

This error means that the file name already exists in that location and is possibly still open. You will want to move/close/delete the other file and try again or choose a different location.

Attempt solution listed. If problem persists put in a support ticket via Jira.

Problem - Error Selecting Item on Project Change Order

Receiving this error trying to Select AQ Line # in Project Change Order screen:

ORACLE error: unable to INSERT record.

FRM-40508

ORA-01461: can bind a LONG value only for Insert into a

LONG column

Solution

The Item’s description is too large. Go to the Project Material Plan and shorten the description.

Attempt solution listed. If problem persists put in a support ticket via Jira.

Problem - Can’t Process Refund Branch_Key Error

Receiving this error trying to process a refund:

Voucher Master Not Created: OTHERS error at Insering

Master Input - ORA-01400: cannot insert NULL into

(“ENTERPRISE”.”APY_VOUCHER_MASTER_INPUT”.”

BRANCH_KEY”)

Solution

Need to add Branch to Customer record (A/R>Customers>Enter/Edit Customers). If issue persists put in a support ticket via Jira.

Problem - AQ Import Error Can’t Read File

Trying to import an AQ file, but they are getting a read file error

WUT-129: Error in reading client file

C:\{file location}\Jerry?s_Bagels.json

Solution

Review the file name in the error message and remove the character that shows a '?'. In the above example, the issue is the ' in Jerry’s_Bagels.json. It may be another character, but apostrophes are the most common

Corrected by User. Issue is '?' or other bad character(s) in file name. If the character is not found and still stopping the import put in a support ticket via Jira.

Problem - Order locked in Hold or Shipping Screen

Trying to release/ship an order, but it is saying a user is locking the record

Solution

This usually occurs when a users session crashes or is killed while reviewing an Order. The User that did this needs to open the order, save, then close. This should unlock it.

Attempt solution listed. If problem persists put in a support ticket via Jira.

Problem - Error Processing Orders/Invoices Avalara Avatax

Receiving error trying to process an order through AQ import, Copy, etc..

UORD(8432): Customer 1159 --(will be unique per Customer)

User-Defined Exception when Completing JSON body

Solution

The Customer is missing a valid Zip Code. Correct the Customer contact record.

Attempt solution listed. If problem persists put in a support ticket via Jira.

Corrected by Development

Problem - Error Printing 1099

The file /trx-enterprise/2022.4.1

/apy/apy_print_1099_nec_2022.rep is missing. Report

cannot be printed.

Solution

Put in a support ticket via Jira.

Problem - Vendor Address Not on PO

When PO prints, the address isn’t valid. This is caused by the Vendor Contacts overlapping keys with the training company.

Solution

Put in a support ticket via Jira.

Problem - Error Processing Orders/Shipments

Receiving a Web Order Status error when processing in Order Entry or Order Shipments.

Process_Orders: error when Updating Web Order Status

ORA-06508: PL/SQL: could not find program unit being

called

or in Shipping

ORA-06508: PL/SQL: could not find program unit being

called during Updating Web Order Status

Solution

Put in a support ticket via Jira.

Problem - Validation Error on Report Criteria

Receive a Validation error when selecting an item in a report

WHEN-VALIDATE-ITEM trigger raised unhandled exception ORA-06502.

FRM-40735

ORA-01403: no data found

Solution

Put in a support ticket via Jira.

Problem - Item Description error

Receive Description error selecting item in Project Change Order screen, even though description is within the limit.

Cannot Update Record, Please check the item description and shorten to 3k character or less.

ORA-01461: can bind a LONG value only for insert into a LONG column

Solution

Put in a support ticket via Jira.

Problem - Error adding Items in Order Entry

Receiving a Calc_totals Program Unit error entering items in Order Entry.

Calc_totals Program UnitOthers

100501: non-ORACLE exception

Solution

Put in a support ticket via Jira.

Corrected by IT

Problem - Can’t Download AQ data to Update Pricing

When Downloading Manufacturer or Products data from AQ, User is receiving a Time-Out issue.

Time-Out when receiving http request. Please contact support.

Solution

Put in a support ticket via Jira.

Problem - Gateway - Processing System Down

Singer (T&L) have a CC processor that will occasionally go down.

They will report that they are down/Can’t process Credit Cards

Solution

Put in a support ticket via Jira.

Problem - Error Downloading Orders from Web

When you try to import orders you get this error message:

Error getting Orders from API: Exiting with error

Solution

Put in a support ticket via Jira.

Problem - Disk Error / Server Crash

Receiving Disk I/O error and Unable to allocate record buffer when using system. Could be in a screen or running a report.

FRM-41839: Disk I/O error on temporary record buffer file

FRM-40900: Unable to allocate record buffer. Clear for to continue

Solution

Put in a support ticket via Jira.

Problem - Error Printing Reports

Receive error printing any documents

Report could not be generated due to an error

REP-51002: Bind to Reports Server rptsvr_state_enterprise_inst failed.

Solution

Put in a support ticket via Jira.

Problem - Users Can’t Login Archiver Error

Receive an Archiver Error trying to Login to TRX

ORA-00257: archiver error. Connect internal only, until freed

Solution

Put in a support ticket via Jira.

Problem - Users Can’t Login TNS Listener Error

Receive a TNS Error trying to Login to TRX

ORA-12505: TNS: listener does not currently know of SID

given in connect descriptor

Solution

Put in a support ticket via Jira.