'Cannot insert the value NULL into column loginstance table AUSR'

[Former Member]

Hi Experts,

Does anyone know how to fix this error messages which users are getting when they log on to SAP B1? The message appears momentarily and then disappears. They can then work as normal.

Regards Martin

[ladislav_meszaros]

Hi Martin,

This issue has been fixed in 8.81 PL11. Please refer to note [1653119|https://websmp130.sap-ag.de/sap(bD1odSZjPTAwMQ==)/bc/bsp/spn/sapnotes/index2.htm?numm=1653119]. As a solution I would suggest to upgrade to the latest patch level of 8.81 version.

hope it helps,

Regards,

Ladislav Meszaros

SAP Business One Forum Team

[Former Member]

Hi Martin,

Apparently, something is wrong with your AUSR table. I would suggest you to make a backup of this table and clean it up.

Thanks,

Gordon