SQL Error (SQLSTATE=23502) - Assignment of a Null value to a Not Null Column

Resolved SQL Error (SQLSTATE=23502) - Assignment of a Null value to a Not Null Column

Issue

Votes

Undo

PremKumar Mani
PowerBuilder
Monday, 19 October 2020 15:03 PM UTC

I am facing an issue as shown in the attached screenshot. The issue occurs when generating an Excel Report. The same functionality is working in PB 8.0 but only in PB 2019R2 I am seeing this error. Requesting you to provide a solution to fix this issue.

Responses (1)

Chris Pollach @Appeon Accepted Answer Pending Moderation

Monday, 19 October 2020 17:23 PM UTC
PowerBuilder
# 1

Hi PremKumar;

Definitely a DBMS NULL based error. I would check your in-line SQL or the App DWO's "Update Properties" to ensure that ...

1) The Null column is indeed one that needs to be updated

2) Run through the debugger to see if your App's code actually initializes the column's value

3) Use an SQL Trace to to view more detail ..

SQLCA.DBMS ="XXX" // Current

SQLCA.DBMS = "TRACE XXX" // new

TIP: To see more SQL in the trace ...

SQLCA.DBParm = "DisableBind=1"

Regards ... Chris

Comment

There are no comments made yet.

Page :
1

There are no replies made for this question yet.
However, you are not allowed to reply to this question.

Please login to post a reply

You will need to be logged in to be able to post a reply. Login using the form on the right or register an account if you are new here. Register Here »

Forgot Password?

We use cookies which are necessary for the proper functioning of our websites. We also use cookies to analyze our traffic, improve your experience and provide social media features. If you continue to use this site, you consent to our use of cookies.