are you restoring or backing up?
i hope you're backing up, because in this case you can check your standard text table (code fields) for strange or lowercase characters.
Then, correct them and redo the backup.
if you are restoring, you have to check the original db, correct the values and then redo the backup.
-Mirko-
"Never memorize what you can easily find in a book".....Or Mibuso My Blog
Thanks for all who suggested me solution for this issue.........
This issue has been sorted. I have deleted records in Standard Text Table thr back end (SQL Server). Now i can able to take backup. Might be some data problem in Standard Text Table.
Dont delete the data any time.
[-X
you may face problem later.
true...but deletion of data can be sometimes a miracle 8)
anyway, investigate WHAT is the wrong data, then correct sql store procedures accordingly.
for example, do an uppercase to all code fields
-Mirko-
"Never memorize what you can easily find in a book".....Or Mibuso My Blog
Dont delete the data any time.
[-X
you may face problem later.
true...but deletion of data can be sometimes a miracle 8)
anyway, investigate WHAT is the wrong data, then correct sql store procedures accordingly.
for example, do an uppercase to all code fields
As the datatype of field code is CODE, i think no need to write in uppercase.
maybe i didn't explain correctly:
if you insert a lowercase value in SQL (through sql scripts or manually from management studio) in a code field, it will remain as is.
Nav can't read this value and often crashes when trying to read the value.
-Mirko-
"Never memorize what you can easily find in a book".....Or Mibuso My Blog
maybe i didn't explain correctly:
if you insert a lowercase value in SQL (through sql scripts or manually from management studio) in a code field, it will remain as is.
Nav can't read this value and often crashes when trying to read the value.
Answers
i hope you're backing up, because in this case you can check your standard text table (code fields) for strange or lowercase characters.
Then, correct them and redo the backup.
if you are restoring, you have to check the original db, correct the values and then redo the backup.
"Never memorize what you can easily find in a book".....Or Mibuso
My Blog
This issue has been sorted. I have deleted records in Standard Text Table thr back end (SQL Server). Now i can able to take backup. Might be some data problem in Standard Text Table.
Once again thank u...
Dont delete the data any time.
[-X
you may face problem later.
-Mohana
http://mohana-dynamicsnav.blogspot.in/
https://www.facebook.com/MohanaDynamicsNav
true...but deletion of data can be sometimes a miracle 8)
anyway, investigate WHAT is the wrong data, then correct sql store procedures accordingly.
for example, do an uppercase to all code fields
"Never memorize what you can easily find in a book".....Or Mibuso
My Blog
As the datatype of field code is CODE, i think no need to write in uppercase.
but i think the problem is with length. :-k
-Mohana
http://mohana-dynamicsnav.blogspot.in/
https://www.facebook.com/MohanaDynamicsNav
if you insert a lowercase value in SQL (through sql scripts or manually from management studio) in a code field, it will remain as is.
Nav can't read this value and often crashes when trying to read the value.
"Never memorize what you can easily find in a book".....Or Mibuso
My Blog
Ok :-#
-Mohana
http://mohana-dynamicsnav.blogspot.in/
https://www.facebook.com/MohanaDynamicsNav
"Never memorize what you can easily find in a book".....Or Mibuso
My Blog