Whenever I try to click on Item, to see items list from Navigation Pane, it gives me an error of saying " MS SQL Server cannot insert the value NULL into column ' BASEUOFM', table 'tempdb.dbo.##XXXXXXX; column does not allow nulls. INSERT fails
Take a look at your IV10401, IV30701 and IV40201. Each of those tables contain the BASEUOFM column. Look and see if any record has a blank in that column.
"viol-8-r" wrote: > Whenever I try to click on Item, to see items list from Navigation Pane, it > gives me an error of saying " MS SQL Server cannot insert the value NULL > into column ' BASEUOFM', table 'tempdb.dbo.##XXXXXXX; column does not allow > nulls. INSERT fails
Hi Leslie, Thanks for your kind reply. I have checked all the 3 tables you mentioned below but I have no luck resolving this issue. I am not able to find any blank column in any of the table. Any other suggestion ? Regards,
"Leslie Vail" <LeslieV...@discussions.microsoft.com> wrote in message
> Take a look at your IV10401, IV30701 and IV40201. Each of those tables > contain the BASEUOFM column. Look and see if any record has a blank in > that > column.
> "viol-8-r" wrote:
>> Whenever I try to click on Item, to see items list from Navigation Pane, >> it >> gives me an error of saying " MS SQL Server cannot insert the value NULL >> into column ' BASEUOFM', table 'tempdb.dbo.##XXXXXXX; column does not >> allow >> nulls. INSERT fails
I would generate the error again and record the name of the temp table in the message.
Then, get everyone out of Dynamics. Back up your tempdb (seems odd, but better safe than sorry). Open the temdb in SQL Server Management Studio, select the Temporary Tables item and then delete the referenced tempdb.dbo.##XXXXXXX table.
"viol-8-r" wrote: > Hi Leslie, > Thanks for your kind reply. I have checked all the 3 tables you mentioned > below but I have no luck resolving this issue. I am not able to find any > blank column in any of the table. > Any other suggestion ? > Regards,
> "Leslie Vail" <LeslieV...@discussions.microsoft.com> wrote in message > news:A8C40B2B-08E2-436B-8061-C6C8973CC051@microsoft.com... > > Take a look at your IV10401, IV30701 and IV40201. Each of those tables > > contain the BASEUOFM column. Look and see if any record has a blank in > > that > > column.
> > "viol-8-r" wrote:
> >> Whenever I try to click on Item, to see items list from Navigation Pane, > >> it > >> gives me an error of saying " MS SQL Server cannot insert the value NULL > >> into column ' BASEUOFM', table 'tempdb.dbo.##XXXXXXX; column does not > >> allow > >> nulls. INSERT fails
I think you have identified a bug. I reinstalled by system to 1378 and the error was there. I upgraded to build 1411 and the error was there. It seems like it throws the error with each new temp file it creates. I will check the error log and see if this one has been logged.
"viol-8-r" wrote: > Whenever I try to click on Item, to see items list from Navigation Pane, it > gives me an error of saying " MS SQL Server cannot insert the value NULL > into column ' BASEUOFM', table 'tempdb.dbo.##XXXXXXX; column does not allow > nulls. INSERT fails
I went back and re-installed gp and brought it forward from build 1328 (1378?). The error you spoke of could not be removed by deleting the temp table. I upgraded to build 1411 and still no luck. I upgraded to build 1502 and presto! The error message went away.
"viol-8-r" wrote: > Hi Leslie, > Thanks for your kind reply. I have checked all the 3 tables you mentioned > below but I have no luck resolving this issue. I am not able to find any > blank column in any of the table. > Any other suggestion ? > Regards,
> "Leslie Vail" <LeslieV...@discussions.microsoft.com> wrote in message > news:A8C40B2B-08E2-436B-8061-C6C8973CC051@microsoft.com... > > Take a look at your IV10401, IV30701 and IV40201. Each of those tables > > contain the BASEUOFM column. Look and see if any record has a blank in > > that > > column.
> > "viol-8-r" wrote:
> >> Whenever I try to click on Item, to see items list from Navigation Pane, > >> it > >> gives me an error of saying " MS SQL Server cannot insert the value NULL > >> into column ' BASEUOFM', table 'tempdb.dbo.##XXXXXXX; column does not > >> allow > >> nulls. INSERT fails
Hi Leslie, It could also be a bug but what I finally found; was a row created by checklinks in IV00101 with a BUOMSCHEDUL Blank which when I deleted worked fine. Thank you so much for taking some extra efforts to rescue me. It is highly appreciated, Regards
"Leslie Vail" <LeslieV...@discussions.microsoft.com> wrote in message
> I think you have identified a bug. I reinstalled by system to 1378 and the > error was there. I upgraded to build 1411 and the error was there. It > seems > like it throws the error with each new temp file it creates. I will check > the > error log and see if this one has been logged.
> Kind regards,
> Leslie
> "viol-8-r" wrote:
>> Whenever I try to click on Item, to see items list from Navigation Pane, >> it >> gives me an error of saying " MS SQL Server cannot insert the value NULL >> into column ' BASEUOFM', table 'tempdb.dbo.##XXXXXXX; column does not >> allow >> nulls. INSERT fails
