Microsoft KB Archive/323904

= BUG: Validation in AutogenTime for Fiscal Calendar Does Not Trap Invalid First Day of Month =

Article ID: 323904

Article Last Modified on 5/6/2003

-

APPLIES TO


 * Microsoft Solution Offering - Microsoft SQL Server Accelerator for Business Intelligence

-



This article was previously published under Q323904



SYMPTOMS
If the First Day of Month value for the Fiscal calendar is not valid in the AutogenTime worksheet of the Analytics Builder workbook, the worksheet validates. However, when you click Generate Application to generate the application from the workbook, the following error is logged:

Error: Arithmetic overflow error converting expression to data type smalldatetime.

Location: CreateSQLDatabases/ExecSP_Sym_Create

Analytics Builder processing halted unexpectedly.



STATUS
Microsoft has confirmed that this is a bug in the Microsoft products that are listed at the beginning of this article.



Step to Reproduce the Behavior
 Open the Analytics Builder workbook. In the AutogenTime worksheet of the Analytics Builder workbook, click to select the Fiscal check box to enable the Fiscal calendar. In the First Month of Year box, type 2 . In the First Day of Month box, type 30 . On ABW Toolbar menu, click Validate this sheet to validate the AutogenTime worksheet. You receive the following message in the Analytics Builder workbook:

Success. Sheet AutogenTime passed validation. Click OK to close the message box.

 In the Analytics Builder workbook, click the Processing worksheet.</li> Click Generate Application to generate the application from the workbook. The following error is logged in the Microsoft Analytics Builder Workbook Logfile of the Log  worksheet:

Error: Arithmetic overflow error converting expression to data type smalldatetime.

Location: CreateSQLDatabases/ExecSP_Sym_Create

Analytics Builder processing halted unexpectedly.

</li></ol>

Additional query words: SSABI AutogenTime First Month of Year Day

Keywords: kberrmsg kbbug kbpending KB323904

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.