We are running the following expression definition,
IF ( [Database Layer].[AR Invoice Summary].[Posting Date_num] not in (#$Date{'Default Date Integer'}# , #$Date{'Zero Date Integer'}# ) ) THEN
( cast_timestamp (
substring( cast_varchar( [Database Layer].[AR Invoice Summary].[Posting Date_num] ), 1, 4 ) || '-' ||
substring( cast_varchar( [Database Layer].[AR Invoice Summary].[Posting Date_num] ), 5, 2 ) || '-' ||
substring( cast_varchar( [Database Layer].[AR Invoice Summary].[Posting Date_num] ), 7, 2 )
) ) ELSE ( NULL )
We get the following error when trying to Test Sample,
QP-DEF-0177 An error occurred while performing operation 'sqlPrepareWithOptions' status='-69'.
UDA-SQL-0043 The underlying database detected an error during processing the SQL request.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Incorrect syntax near '|'.
[Microsoft][SQL Server Native Client 10.0][SQL Server]Statement(s) could not be prepared.
Has anyone run into this or have any suggestions into changes that can be made to the expression? Pic is attached. We are running sql 2008 r2. This is a singel server environment. Fwm version 10.2.1 with fp installed. Thank you in advance for your time!
Working with IBM Tech support we identified the issue and they created this technote, http://www-01.ibm.com/support/docview.wss?uid=swg21695817