80
I have seen this error before. When attempting to open an existing type Matrix, we get a RUNTIME ERROR: 94 Invalid Use of NULL. This does not occur on every Matrix.
This problem may have become more pronounced after upgrading the SQL Server to 2014 Express
I have been researching and experimenting on a recurring problem, RUNTIME ERROR: 94 Invalid Use of Null. The error mostly occurs when opening an existing MATRIX item. The matrix components are not effected and can be opened as usual.
In my research, I found a response to the same question I asked the community forum back in 2013. It replied that this problem was originally reported in QUICKSELL 2000.
QS2000 was the Sales Management System application that Quicksell Commerce and RMS was evolved from.
The answer suggested the following 3 queries.
SELECT * FROM (Item, ItemClass, and ItemClassComponent).
Run each query and look for NULL values and if found, run another query
UPDATE (Item),(ItemClass),(ItemClassComponent) SET <column name> = 0 WHERE ID = <id>
This did not solve my issue but may help others.
If any other suggestions are out there, please let me know.
Hi! I went back through 5 years of support ticket history and could not find any support tickets with that error message. Have you made a backup of the Db and then tried re-indexing? Have you checked to make sure that the matrix items are all set up correctly with no black or missing fields?
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,214
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (