Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Navigation pane - Error when try to clink on Item and few other line BOMs

39 views
Skip to first unread message

viol-8-r

unread,
Jul 6, 2010, 11:16:53 AM7/6/10
to
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 wonder why it does
Please help

Leslie Vail

unread,
Jul 9, 2010, 9:31:11 PM7/9/10
to
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

unread,
Jul 13, 2010, 12:45:00 PM7/13/10
to
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" <Lesli...@discussions.microsoft.com> wrote in message
news:A8C40B2B-08E2-436B...@microsoft.com...

Leslie Vail

unread,
Jul 13, 2010, 8:02:37 PM7/13/10
to
Hi viol-8-r,

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.

Let us know if it works.

Kind regards,

Leslie

"viol-8-r" wrote:

> .
>

Leslie Vail

unread,
Jul 14, 2010, 4:49:20 AM7/14/10
to
viol-8-r,

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

Leslie Vail

unread,
Jul 14, 2010, 4:46:19 PM7/14/10
to
Hi viol-8-r,

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.

What build are you on?

Kind regards,

Leslie

"viol-8-r" wrote:

> .
>

viol-8-r

unread,
Jul 15, 2010, 4:05:19 PM7/15/10
to
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" <Lesli...@discussions.microsoft.com> wrote in message

news:FAAFD7EE-26C6-40B9...@microsoft.com...

0 new messages