Databases
StackOverflow2013
Postsdbo
POSharepoint Business Data List Behavior
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POSharepoint Business Data List Behavior
    primarykey
    data
    text
    <p>This is a multi faceted question, but any help is appreciated </p> <p>Background:</p> <ol> <li>I have a Application Definition with 6 entities using SSO</li> <li>The database back end is Firebird through ODBC</li> <li>All the data is coming from stored procedures</li> </ol> <p>Questions:</p> <p>1 While trying to implement one or any of the entities from the BDC in a Business Data List web part I get the following error: "An error occurred while retrieving data from . Administrators, see the server log for more information." It only happens when I have fields that are null, in this instance a field that was declared as a string.</p> <p>2.When I check the logs, it's a System.OverFlowException. </p> <p>3.If I change it so the output from the procedure is a blank string, I suddenly get "The title property of entity is set to an invalid value" </p> <p>4.The error from the logs after changing to a blank string is "Exception handed to HandleXslException.HandleException System.ArgumentException: '.', hexadecimal value 0x00, is an invalid character" What gives? It worked last night without issue until a record appeared that had a null value in one of the string field. Now, even replacing the null value with something generic is still giving me the title property invalid error.</p> <p>Most puzzling: If I change the query so that the rows with what would be a null or blank string aren't in the query, the error goes away. But, if I add them back and replace the null string with anything, the error comes back. What the !@#$? How does it know I've replaced a null value with something else before the records are returned to the XmlReader?</p>
    singulars
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PTQuestion
    1. This table or related slice is empty.
    1. USSam
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POSharepoint Business Data List Behavior
      1. This table or related slice is empty.
      1. VTUpMod
    1. COIn case someone else comes across this issue: I set the encoding to be unicode on all varchar and char outputs and it fixed it. The lack of encoding caused there to be null characters (not a null record, but one null character) for that column and Sharepoint could not parse the field. Changed the encoding, and everything works.
      singulars
      1. POSharepoint Business Data List Behavior
      1. USSam
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload