General discussion

Locked

SQLDupmpExceptionHandler: Process 15

By arutjothi ·
WHEN I EXECUTE THE FOLLOWING QUERY, I GOT A ERROR.

SELECT INVENTORY_TABLE.ITEM_MAS_ID, INVENTORY_TABLE.TOTAL_USAGE
INTO MasIdAndTotalUsage
FROM INVENTORY_TABLE INNER JOIN ITEM_MASTER
ON INVENTORY_TABLE.ITEM_MAS_ID = ITEM_MASTER.ITEM_MAS_ID
WHERE
ITEM_MASTER.CO_ID = 35 AND
ITEM_MASTER.LOC_ID = 5

THE ERROR IS,

ODBC: MSG 0, LEVEL 19, STATE 1
SQLDupmpExceptionHandler: Process 15 generated fatal exception c0000093 EXCEPTION_FLT_UNDERFLOW. SQL Server is terminating this process.


TABLE STRUCTURE:

1. ITEM_MASTER

NO. OF FIELDS .... 50
NO. OF RECORDS .... 228966
PRIMARY KEY .... ITEM_MAS_ID

2. INVENTORY_TABLE

NO. OF FIELDS .... 46
NO. OF RECORDS .... 224153
PRIMARY KEY .... ITEM_MAS_ID + INV_ID
FOREIGH KEY .... ITEM_MASTER.ITEM_MS_ID

Could you please give the solution

This conversation is currently closed to new comments.

2 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Back to Desktop Forum
2 total posts (Page 1 of 1)  

Related Discussions

Related Forums