Could it be assumed that a stored procedure, activated internally by Service Broker, is executed under the same environmental variables (resource allocation specifically) than when that same stored procedure is executed via an EXEC statement from a non-Service Broker procedure?
When I have 10 of these procedures running (somewhat concurrently) overall performance is not even close as to when I let Service Broker activate the procedure via 10 messages on the queue. If all variables are equal than I am not sure why this is. Or is it possible that everything is not equal?
I've read already every thread in this forum regarding this topic with no results.
SQLServer and the corresponding services are at actual update level. The reporting services worked for 4 months without this problem. Suddenly, most of the time all reports return an internal error (it is like 70-30 for internal error) not depending which render format is used.
The system logs (eventlog, iis) show no errors. The ExecutionLog of RS show rsInternalError.
Looking in the log files in RS log directory, there is following stacktrace:
i have a table with a status field. this status field is incremented by 2 if the entry is reviewed and considered ok to be published. is it possible to increment this field without first selecting and eval it? is it possible to do something like this:
I have set up the transactional replication. MY log reader process wakes up and runs every 5 min. Does my transactions will get deleted or they still in log file as active even it is in simple recover model.
Logreader how it reads the Transaction log files .? I observed today we are running some big reports. those reports uses INSERT INTO FROM <TABLE > this process showing in DBCC OPENTRAN
MY log reader keep on reading the log file.. it did not come out from that five min duration...
Can someone from the MS share the what /how exactly log reader works ( inside details)
I would like to add more details
The Log Reader Agent is scanning the transaction log for commands to be replicated. Approximately 30500000 log records have been scanned in pass # 3, 1696 of which were marked for replication, elapsed time -623164036 (ms).
The Log Reader Agent is scanning the transaction log for commands to be replicated. Approximately 31000000 log records have been scanned in pass # 3, 1713 of which were marked for replication, elapsed time -177869239 (ms).
everytiome counter startwith 500000 records and keegoing for some time and it is delivering the transactions never stopping the job
What causes locks on the internal Service Broker tables? I notice in my service broker application that when a lot of messages are being passed around, there are a lot of locks being issued on some internal service broker tables (queue_messages_). Are the locks caused from RECEIVE statements being issued against the queues, or is it something else? Can anything be done to decrease the locking? In my current application, I am reusing dialogs and receiving messages from the queue in bulk rather than receiving the first one from activation. Is there anything else I should be looking specifically to do to increase performance?
I have the following code and I keep on getting the following error: Internal SQL Server error. Line 160: da.Fill(dtStudent) <code> Private Function CreateStudentDT() As DataTable
Dim cmdStudent As SqlCommand = New SqlCommand Dim strSPName As String Dim strSQL As String Dim dtStudent As New DataTable cmdStudent.Connection = objConn cmdStudent.CommandType = CommandType.StoredProcedure cmdStudent.Parameters.Add("@ParamYear", mprmYear.Code) cmdStudent.Parameters.Add("@paramDate", mstrParamToDate) cmdStudent.Parameters.Add("@ParamMonth", mprmMonth.Code) cmdStudent.CommandText = "AmountMarkedMosad" objConn.Open() Dim da As SqlDataAdapter = New SqlClient.SqlDataAdapter(cmdStudent) da.Fill(dtStudent) objConn.Close() Return dtStudent End Function
I am trying to create custom reports with Access by linking to SQL tables in the SMS 2.0 software metering database. The only problem that I am having is trying to convert the internal SQL time/date nine digit format for when programs started or ended to a standard format. Is there a special function within either SQL or Access that will do this? Thanks.
HELP! I ran a script that performed a rather large (and lengthy) update and alter with the result being correct however, now a number of stored procedures return an "Internal SQL Server Error" containing joins to the above altered tables? Has anyone hit this before? Does the error really mean a SQL Server problem or database specific problem? Does anyone know how to remidy the situation?
Can someone pleplease run the script below in SQL2K environment with SP3+ applied and see if you get the same error:create view dbo.vw_INTERNAL_ERROR asselect top 100 percent * from( select [DateField]=getdate()) x1 order by x1.[DateField]goif exists(select 1 from dbo.vw_INTERNAL_ERROR)print 'Exists'elseprint 'Doesn''t Exist'godrop view dbo.vw_INTERNAL_ERRORgo I am getting this: Msg 8624, Level 16, State 23, Line 1Internal SQL Server error. But in SQL2K5 it prints 'Exists' correctly. Thanks in advance.
Server: Msg 8624, Level 16, State 1, Procedure SiteProdRatesCalc, Line 890 Internal SQL Server error. DELETING ANY SITEPRODUCTRATES ENTERED TODAY FOR FC, OT, NT BY SITE GROUP CALCULATING RATES FROM ONE RATE SOURCE.
I have been running log shipping for more than a year now and it has been very successful until just recently. For some reason the SQL Agent jobs that backup the database, ship it across the network to a standby server and restore it are failing. On the source server the backup process is running, the log shipping is running however when it tries to restore it on the destination server it fails with the following error:
SQL Server Help file: Help context: 0 Error Detail Records: Error: -2147217900 (80040E14); Provider Error: 3013 (BC5) Error string: RESTORE DATABASE is terminating abnormally. Error source: Microsoft OLE DB Provider for SQL Server Help file: Help context: 0 Error: -2147217900 (80040E14); Provider Error: 3270 (CC6) Error string: An internal consistency error occurred. Contact Technical Support for assistance. Error source: Microsoft OLE DB Provider for SQL Server Help file: Help context: 0 Error: 0 (0); Provider Error: 3211 (C8B) Error string: 10 percent restored. Error source: Microsoft OLE DB Prov... Process Exit Code 1. The step failed.
If I delete the database on the destination server, re-run the sql agent job that ships the backup job, and re-run the restore job on the destination server the process will succeed without error. This tells me the original backup was fine but something may have been lost during the shipping. Have you ever seen this message before? What does it mean and what should I be looking at to resolve the error?
I have 2 boxes, 1 webserver and 1 db server, both behind a firewall. For the past few years I have been connecting from the webserver to the db server using a public IP. I have 2 NIC's in the DB server so I now want to connect locally to reduce our companies bandwidth charges, and hopefully make things a tiny bit faster too. I'm not sure if it will make a difference, but should be interesting.
I'm having problems setting this up tho, what steps do I need to take to make sure it works properly?
When I check my DB servers IP configuration I get 2 NICs'
One configured as an external IP, the other configued as 169.xxx.xx.xxx
I am trying to connect using the 169.xxx.xx.xx Is this the correct approach? I am getting TimeOut Errors as seen below
I looked in my SQL configuration and its set to allow remote connections however, and since I was connecting over a public IP before, this seems contridicting.
Any help is much appreciated.
Thanks once again!!! :) mike123
System.Data.SqlClient.SqlException: An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)
Hi, Im getting a strange error, in some cases when using a table in reporting services, if I delete some columns however, the error disapears, bellow is the error string, How can I increase the lenght of the LOB data?
thank you
----------------------------------------------------- w3wp!library!7!09/21/2007-08:51:23:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details., ; Info: Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details. ---> System.Data.SqlClient.SqlException: Length of LOB data (97840) to be replicated exceeds configured maximum 65536. The statement has been terminated.
I am going crazy!! We have a new server with 80GB RAM. I restore a database a little over 3TB, EXEC DBCC CHECKDB and receive the output below which conitues to error on tempdb any idea why tempdb?? Thanks for any help!!
**** Msg 5242, Level 16, State 1, Server KNXPNAETLSQL2005, Line 1 An inconsistency was detected during an internal operation in database 'tempdb'(ID:2) on page (17:4003567). Please contact technical support. Reference number 4. The statement has been terminated. Msg 5242, Level 16, State 1, Server KNXPNAETLSQL2005, Line 1 An inconsistency was detected during an internal operation in database 'tempdb'(ID:2) on page (15:913355). Please contact technical support. Reference number 3. The statement has been terminated. Msg 5242, Level 16, State 1, Server KNXPNAETLSQL2005, Line 1 An inconsistency was detected during an internal operation in database 'tempdb'(ID:2) on page (9:3514551). Please contact technical support. Reference number 4. The statement has been terminated. Msg 5242, Level 16, State 1, Server KNXPNAETLSQL2005, Line 1 An inconsistency was detected during an internal operation in database 'tempdb'(ID:2) on page (18:2808171). Please contact technical support. Reference number 4. The statement has been terminated. DBCC results for 'SalesDM'. Service Broker Msg 9675, State 1: Message Types analyzed: 14. Service Broker Msg 9676, State 1: Service Contracts analyzed: 6. Service Broker Msg 9667, State 1: Services analyzed: 3. Service Broker Msg 9668, State 1: Service Queues analyzed: 3. Service Broker Msg 9669, State 1: Conversation Endpoints analyzed: 0. Service Broker Msg 9674, State 1: Conversation Groups analyzed: 0. Service Broker Msg 9670, State 1: Remote Service Bindings analyzed: 0. DBCC results for 'sys.sysrowsetcolumns'. There are 16874 rows in 122 pages for object "sys.sysrowsetcolumns". DBCC results for 'sys.sysrowsets'. There are 2240 rows in 16 pages for object "sys.sysrowsets". DBCC results for 'sysallocunits'. There are 2253 rows in 30 pages for object "sysallocunits". DBCC results for 'sys.sysfiles1'. There are 70 rows in 8 pages for object "sys.sysfiles1". DBCC results for 'sys.syshobtcolumns'. There are 16880 rows in 142 pages for object "sys.syshobtcolumns". DBCC results for 'sys.syshobts'. There are 2240 rows in 16 pages for object "sys.syshobts". DBCC results for 'sys.sysftinds'. There are 0 rows in 0 pages for object "sys.sysftinds". DBCC results for 'sys.sysserefs'. There are 2253 rows in 12 pages for object "sys.sysserefs". DBCC results for 'sys.sysowners'. There are 34 rows in 1 pages for object "sys.sysowners". DBCC results for 'sys.sysprivs'. There are 180 rows in 1 pages for object "sys.sysprivs". DBCC results for 'sys.sysschobjs'. There are 1271 rows in 24 pages for object "sys.sysschobjs". DBCC results for 'sys.syscolpars'. There are 16219 rows in 313 pages for object "sys.syscolpars". DBCC results for 'sys.sysnsobjs'. There are 1 rows in 1 pages for object "sys.sysnsobjs". DBCC results for 'sys.syscerts'. There are 0 rows in 0 pages for object "sys.syscerts". DBCC results for 'sys.sysxprops'. There are 14 rows in 4 pages for object "sys.sysxprops". DBCC results for 'sys.sysscalartypes'. There are 28 rows in 1 pages for object "sys.sysscalartypes". DBCC results for 'sys.systypedsubobjs'. There are 0 rows in 0 pages for object "sys.systypedsubobjs". DBCC results for 'sys.sysidxstats'. There are 8087 rows in 172 pages for object "sys.sysidxstats". DBCC results for 'sys.sysiscols'. There are 8981 rows in 72 pages for object "sys.sysiscols". DBCC results for 'sys.sysbinobjs'. There are 23 rows in 1 pages for object "sys.sysbinobjs". DBCC results for 'sys.sysobjvalues'. There are 8428 rows in 5734 pages for object "sys.sysobjvalues". DBCC results for 'sys.sysclsobjs'. There are 82 rows in 1 pages for object "sys.sysclsobjs". DBCC results for 'sys.sysrowsetrefs'. There are 0 rows in 0 pages for object "sys.sysrowsetrefs". DBCC results for 'sys.sysremsvcbinds'. There are 0 rows in 0 pages for object "sys.sysremsvcbinds". DBCC results for 'sys.sysxmitqueue'. There are 0 rows in 0 pages for object "sys.sysxmitqueue". DBCC results for 'sys.sysrts'. There are 1 rows in 1 pages for object "sys.sysrts". DBCC results for 'sys.sysconvgroup'. There are 0 rows in 0 pages for object "sys.sysconvgroup". DBCC results for 'sys.sysdesend'. There are 0 rows in 0 pages for object "sys.sysdesend". DBCC results for 'sys.sysdercv'. There are 0 rows in 0 pages for object "sys.sysdercv". DBCC results for 'sys.syssingleobjrefs'. There are 293 rows in 2 pages for object "sys.syssingleobjrefs". DBCC results for 'sys.sysmultiobjrefs'. There are 12726 rows in 93 pages for object "sys.sysmultiobjrefs". DBCC results for 'sys.sysdbfiles'. There are 70 rows in 4 pages for object "sys.sysdbfiles". DBCC results for 'sys.sysguidrefs'. There are 68 rows in 1 pages for object "sys.sysguidrefs". DBCC results for 'sys.sysqnames'. There are 92 rows in 1 pages for object "sys.sysqnames". DBCC results for 'sys.sysxmlcomponent'. There are 93 rows in 1 pages for object "sys.sysxmlcomponent". DBCC results for 'sys.sysxmlfacet'. There are 97 rows in 1 pages for object "sys.sysxmlfacet". DBCC results for 'sys.sysxmlplacement'. There are 17 rows in 1 pages for object "sys.sysxmlplacement". DBCC results for 'sys.sysobjkeycrypts'. There are 0 rows in 0 pages for object "sys.sysobjkeycrypts". DBCC results for 'sys.sysasymkeys'. There are 0 rows in 0 pages for object "sys.sysasymkeys". DBCC results for 'sys.syssqlguides'. There are 0 rows in 0 pages for object "sys.syssqlguides". DBCC results for 'sys.sysbinsubobjs'. There are 0 rows in 0 pages for object "sys.sysbinsubobjs". DBCC results for 'FctTenderBridge200706'. There are 26653646 rows in 69231 pages for object "FctTenderBridge200706". DBCC results for 'FctInventoryDetailOverShort200609'. There are 908219 rows in 18922 pages for object "FctInventoryDetailOverShort200609". DBCC results for 'FctItem200707'. There are 69452016 rows in 1507439 pages for object "FctItem200707". DBCC results for 'FctMarketBasket200802'. There are 0 rows in 0 pages for object "FctMarketBasket200802". DBCC results for 'FctTrans200704'. There are 38540518 rows in 597065 pages for object "FctTrans200704". DBCC results for 'FctInventoryDetailOverShort200608'. There are 1077109 rows in 22440 pages for object "FctInventoryDetailOverShort200608". DBCC results for 'FctMarketBasket200803'. There are 0 rows in 0 pages for object "FctMarketBasket200803". DBCC results for 'FctTrans200705'. There are 42379252 rows in 655684 pages for object "FctTrans200705". DBCC results for 'FctInventoryDetailOverShort200607'. There are 1027581 rows in 21408 pages for object "FctInventoryDetailOverShort200607". DBCC results for 'FctMarketBasket200804'. There are 0 rows in 0 pages for object "FctMarketBasket200804". DBCC results for 'FctPurchases200612'. There are 80697 rows in 8112 pages for object "FctPurchases200612". DBCC results for 'FctTrans'. There are 0 rows in 1 pages for object "FctTrans". DBCC results for 'FctTrans200706'. There are 42427263 rows in 656341 pages for object "FctTrans200706". DBCC results for 'FctInventoryOverShort200701'. There are 11805 rows in 1074 pages for object "FctInventoryOverShort200701". DBCC results for 'FctItem200710'. There are 64543846 rows in 1400823 pages for object "FctItem200710". DBCC results for 'FctMarketBasket200805'. There are 0 rows in 0 pages for object "FctMarketBasket200805". DBCC results for 'FctInventoryOverShort200702'. There are 20945 rows in 1911 pages for object "FctInventoryOverShort200702". DBCC results for 'FctItem200711'. There are 61572408 rows in 1336204 pages for object "FctItem200711". DBCC results for 'AggFctInventory200709'. There are 38674561 rows in 345311 pages for object "AggFctInventory200709". DBCC results for 'FctMarketBasket200806'. There are 0 rows in 0 pages for object "FctMarketBasket200806". DBCC results for 'FctInventoryDetailOverShort200701'. There are 1137310 rows in 23694 pages for object "FctInventoryDetailOverShort200701". DBCC results for 'FctItem200712'. There are 61015139 rows in 1324141 pages for object "FctItem200712". DBCC results for 'FctPurchases200801'. There are 61634 rows in 6165 pages for object "FctPurchases200801". DBCC results for 'FctInventoryDetailOverShort200702'. There are 870050 rows in 25566 pages for object "FctInventoryDetailOverShort200702". DBCC results for 'FctMarketBasket200707'. There are 14738148 rows in 140364 pages for object "FctMarketBasket200707". DBCC results for 'FctPurchasesDetail200611'. There are 1525759 rows in 50859 pages for object "FctPurchasesDetail200611". DBCC results for 'FctInventoryOverShort200612'. There are 11407 rows in 1037 pages for object "FctInventoryOverShort200612". DBCC results for 'FctMarketBasket200708'. There are 14925509 rows in 142148 pages for object "FctMarketBasket200708". DBCC results for 'DimTender'. There are 252 rows in 4 pages for object "DimTender". DBCC results for 'FctInventoryOverShort200611'. There are 20815 rows in 1893 pages for object "FctInventoryOverShort200611". DBCC results for 'FctMarketBasket200709'. There are 12731912 rows in 121257 pages for object "FctMarketBasket200709". DBCC results for 'FctPurchases200802'. There are 0 rows in 0 pages for object "FctPurchases200802". DBCC results for 'FctTrans200603'. There are 36881167 rows in 595900 pages for object "FctTrans200603". DBCC results for 'FctInventoryOverShort200610'. There are 23278 rows in 2117 pages for object "FctInventoryOverShort200610". DBCC results for 'FctMarketBasket200710'. There are 13466682 rows in 128255 pages for object "FctMarketBasket200710". DBCC results for 'DimVendor'. There are 8345 rows in 150 pages for object "DimVendor". DBCC results for 'FctItem200509'. There are 55103852 rows in 1196780 pages for object "FctItem200509". DBCC results for 'DimTime'. There are 210336 rows in 14506 pages for object "DimTime". DBCC results for 'FctInventoryOverShort200609'. There are 21303 rows in 1937 pages for object "FctInventoryOverShort200609". DBCC results for 'FctMarketBasket200711'. There are 12639259 rows in 120374 pages for object "FctMarketBasket200711". DBCC results for 'FctTrans200504'. There are 6346491 rows in 83507 pages for object "FctTrans200504". DBCC results for 'FctPurchasesDetail200610'. There are 1534022 rows in 51135 pages for object "FctPurchasesDetail200610". DBCC results for 'FctInventoryOverShort200608'. There are 22840 rows in 2077 pages for object "FctInventoryOverShort200608". DBCC results for 'FctMarketBasket200712'. There are 12467649 rows in 118740 pages for object "FctMarketBasket200712". DBCC results for 'FctPurchases200803'. There are 0 rows in 0 pages for object "FctPurchases200803". DBCC results for 'FctTrans200502'. There are 5601498 rows in 75783 pages for object "FctTrans200502". DBCC results for 'FctInventoryOverShort200607'. There are 23055 rows in 2096 pages for object "FctInventoryOverShort200607". DBCC results for 'FctPurchases200707'. There are 86938 rows in 8695 pages for object "FctPurchases200707". DBCC results for 'FctItem200504'. There are 6344255 rows in 115351 pages for object "FctItem200504". DBCC results for 'FctInventoryOverShort'. There are 0 rows in 1 pages for object "FctInventoryOverShort". DBCC results for 'AggFctInventory200710'. There are 40548491 rows in 362042 pages for object "AggFctInventory200710". DBCC results for 'FctItem200502'. There are 5846295 rows in 109676 pages for object "FctItem200502". DBCC results for 'FctInventoryDetailOverShort200703'. There are 1080358 rows in 22508 pages for object "FctInventoryDetailOverShort200703". DBCC results for 'FctPurchases200804'. There are 0 rows in 0 pages for object "FctPurchases200804". DBCC results for 'FctItem200402'. There are 2363053 rows in 42965 pages for object "FctItem200402". DBCC results for 'FctTenderBridge200610'. There are 24029388 rows in 62419 pages for object "FctTenderBridge200610". DBCC results for 'DimTransAccount'. There are 23 rows in 1 pages for object "DimTransAccount". DBCC results for 'FctPurchases200708'. There are 89984 rows in 8999 pages for object "FctPurchases200708". DBCC results for 'FctTrans200402'. There are 2363213 rows in 31095 pages for object "FctTrans200402". DBCC results for 'FctItem200403'. There are 2654122 rows in 48257 pages for object "FctItem200403". DBCC results for 'FctTender200610'. There are 36279859 rows in 594752 pages for object "FctTender200610". DBCC results for 'FctItem200603'. There are 58617729 rows in 1272670 pages for object "FctItem200603". DBCC results for 'FctInventoryDetailOverShort'. There are 0 rows in 1 pages for object "FctInventoryDetailOverShort". DBCC results for 'FctPurchases200805'. There are 0 rows in 0 pages for object "FctPurchases200805". DBCC results for 'FctItem200404'. There are 2674211 rows in 48623 pages for object "FctItem200404". DBCC results for 'FctPurchases200709'. There are 81611 rows in 8162 pages for object "FctPurchases200709". DBCC results for 'FctTrans200403'. There are 2655446 rows in 34941 pages for object "FctTrans200403". DBCC results for 'FctTender200611'. There are 35005924 rows in 573868 pages for object "FctTender200611". DBCC results for 'FctPurchasesDetail200609'. There are 1425542 rows in 47519 pages for object "FctPurchasesDetail200609". DBCC results for 'FctTrans200404'. There are 2674418 rows in 35190 pages for object "FctTrans200404". DBCC results for 'FctPurchases200806'. There are 0 rows in 0 pages for object "FctPurchases200806". DBCC results for 'FctTrans200401'. There are 2403683 rows in 31628 pages for object "FctTrans200401". DBCC results for 'vw_FctTransFctTender200612'. There are 22794210 rows in 411662 pages for object "vw_FctTransFctTender200612". DBCC results for 'FctTender200612'. There are 38084959 rows in 624345 pages for object "FctTender200612". DBCC results for 'FctTrans200604'. There are 35887758 rows in 579843 pages for object "FctTrans200604". DBCC results for 'FctPurchases200710'. There are 91429 rows in 9144 pages for object "FctPurchases200710". DBCC results for 'FctItem200401'. There are 2403524 rows in 43701 pages for object "FctItem200401". DBCC results for 'vw_FctItemFctTender200611'. Msg 8908, Level 16, State 1, Server KNXPNAETLSQL2005, Line 1 Indexed view 'vw_FctItemFctTender200611' (object ID 351340316) does not contain all rows that the view definition produces. Refer to Books Online for more information on this error. This does not necessarily represent an integrity issue with the data in this database. There are 56265296 rows in 1003654 pages for object "vw_FctItemFctTender200611". CHECKDB found 0 allocation errors and 1 consistency errors in table 'vw_FctItemFctTender200611' (object ID 351340316). DBCC results for 'FctItem200604'. There are 57288301 rows in 1242370 pages for object "FctItem200604". DBCC results for 'FctPurchases200609'. There are 74084 rows in 7409 pages for object "FctPurchases200609". DBCC results for 'FctItem200501'. There are 4852798 rows in 88233 pages for object "FctItem200501". DBCC results for 'vw_FctTransFctTender200611'. There are 23074679 rows in 378454 pages for object "vw_FctTransFctTender200611". DBCC results for 'FctPurchasesDetail200801'. There are 1125683 rows in 37525 pages for object "FctPurchasesDetail200801". DBCC results for 'FctTenderBridge200605'. There are 23287797 rows in 60489 pages for object "FctTenderBridge200605". DBCC results for 'FctTrans200501'. There are 4854053 rows in 63870 pages for object "FctTrans200501". DBCC results for 'vw_TicketInternalKey200611'. There are 22624684 rows in 70046 pages for object "vw_TicketInternalKey200611". DBCC results for 'FctPurchases200711'. There are 87626 rows in 8764 pages for object "FctPurchases200711". DBCC results for 'FctTenderBridge200604'. There are 23005866 rows in 59759 pages for object "FctTenderBridge200604". DBCC results for 'FctTrans200505'. There are 7073426 rows in 93072 pages for object "FctTrans200505". DBCC results for 'FctPurchasesDetail200608'. There are 1642560 rows in 54752 pages for object "FctPurchasesDetail200608". DBCC results for 'FctTrans200506'. There are 7642026 rows in 100553 pages for object "FctTrans200506". DBCC results for 'AggFctInventory200705'. There are 38969703 rows in 347945 pages for object "AggFctInventory200705". DBCC results for 'FctPurchasesDetail200802'. There are 0 rows in 0 pages for object "FctPurchasesDetail200802". DBCC results for 'FctTenderBridge200603'. There are 23767139 rows in 61737 pages for object "FctTenderBridge200603". DBCC results for 'FctTrans200609'. There are 37186561 rows in 575669 pages for object "FctTrans200609". DBCC results for 'DimCashier'. There are 60954 rows in 791 pages for object "DimCashier". DBCC results for 'FctPurchases200712'. There are 84886 rows in 8491 pages for object "FctPurchases200712". DBCC results for 'FctTenderBridge200602'. There are 19940534 rows in 51796 pages for object "FctTenderBridge200602". DBCC results for 'FctMarketBasket200609'. There are 12290937 rows in 117057 pages for object "FctMarketBasket200609". DBCC results for 'FctPurchases'. There are 0 rows in 1 pages for object "FctPurchases". DBCC results for 'FctTenderBridge200601'. There are 21564340 rows in 56014 pages for object "FctTenderBridge200601". DBCC results for 'FctTrans200507'. There are 8155261 rows in 107307 pages for object "FctTrans200507". DBCC results for 'FctItem200709'. There are 61442354 rows in 1333533 pages for object "FctItem200709". DBCC results for 'FctPurchases200608'. There are 79135 rows in 7914 pages for object "FctPurchases200608". DBCC results for 'FctItem200609'. There are 58642975 rows in 1273085 pages for object "FctItem200609". DBCC results for 'FctPurchasesDetail200803'. There are 0 rows in 0 pages for object "FctPurchasesDetail200803". DBCC results for 'FctTender200601'. There are 32455905 rows in 532067 pages for object "FctTender200601". DBCC results for 'FctItem200708'. There are 69522046 rows in 1508890 pages for object "FctItem200708". DBCC results for 'DimOrg'. There are 779 rows in 262 pages for object "DimOrg". DBCC results for 'FctPurchasesDetail200707'. There are 1751890 rows in 58397 pages for object "FctPurchasesDetail200707". DBCC results for 'AggFctInventory200712'. There are 41688785 rows in 372223 pages for object "AggFctInventory200712". DBCC results for 'FctItem200408'. There are 3454006 rows in 62801 pages for object "FctItem200408". DBCC results for 'FctTender200602'. There are 30080750 rows in 493131 pages for object "FctTender200602". DBCC results for 'FctPurchases200607'. There are 73974 rows in 7398 pages for object "FctPurchases200607". DBCC results for 'FctTrans200408'. There are 3454482 rows in 45454 pages for object "FctTrans200408". DBCC results for 'FctPurchasesDetail200804'. There are 0 rows in 0 pages for object "FctPurchasesDetail200804". DBCC results for 'FctTrans200405'. There are 2780741 rows in 36589 pages for object "FctTrans200405". DBCC results for 'FctPurchasesDetail200708'. There are 1823875 rows in 60796 pages for object "FctPurchasesDetail200708". DBCC results for 'FctTrans200406'. There are 2935300 rows in 38623 pages for object "FctTrans200406". DBCC results for 'DimItemAccount'. There are 10 rows in 1 pages for object "DimItemAccount". DBCC results for 'FctTender200603'. There are 35718186 rows in 585547 pages for object "FctTender200603". DBCC results for 'FctTrans200407'. There are 3288438 rows in 43269 pages for object "FctTrans200407". DBCC results for 'FctPurchasesDetail200607'. There are 1512599 rows in 50420 pages for object "FctPurchasesDetail200607". DBCC results for 'FctPurchasesDetail'. There are 0 rows in 1 pages for object "FctPurchasesDetail". DBCC results for 'FctPurchasesDetail200805'. There are 0 rows in 0 pages for object "FctPurchasesDetail200805". DBCC results for 'FctPurchasesDetail200709'. There are 1586798 rows in 52894 pages for object "FctPurchasesDetail200709". DBCC results for 'FctTender200604'. There are 34580883 rows in 566903 pages for object "FctTender200604". DBCC results for 'FctItem200405'. There are 2780503 rows in 50555 pages for object "FctItem200405". DBCC results for 'FctItem200406'. There are 2934977 rows in 53364 pages for object "FctItem200406". DBCC results for 'DimPriceBook'. There are 118229 rows in 5396 pages for object "DimPriceBook". DBCC results for 'FctPurchasesDetail200806'. There are 0 rows in 0 pages for object "FctPurchasesDetail200806". DBCC results for 'FctTender200605'. There are 34938958 rows in 572773 pages for object "FctTender200605". DBCC results for 'FctItem200407'. There are 3288013 rows in 59783 pages for object "FctItem200407". DBCC results for 'FctPurchasesDetail200710'. There are 1754756 rows in 58492 pages for object "FctPurchasesDetail200710". DBCC results for 'DimCashierScoreCardMetric_200817'. There are 49 rows in 16 pages for object "DimCashierScoreCardMetric_200817". DBCC results for 'FctTender200606'. There are 37162123 rows in 609219 pages for object "FctTender200606". DBCC results for 'FctTender200801'. There are 25344386 rows in 415482 pages for object "FctTender200801". DBCC results for 'FctItem200507'. There are 8152151 rows in 148221 pages for object "FctItem200507". DBCC results for 'vw_TicketInternalKey200610'. There are 23299468 rows in 72135 pages for object "vw_TicketInternalKey200610". DBCC results for 'FctInventory200607'. There are 33332867 rows in 424060 pages for object "FctInventory200607". DBCC results for 'Staging_FOCUSITEMS'. There are 105818 rows in 3320 pages for object "Staging_FOCUSITEMS". DBCC results for 'FctPurchasesDetail200711'. There are 1657167 rows in 55240 pages for object "FctPurchasesDetail200711". DBCC results for 'DimCashierScoreCardMetric'. There are 49 rows in 16 pages for object "DimCashierScoreCardMetric". DBCC results for 'FctItem200506'. There are 7639495 rows in 138900 pages for object "FctItem200506". DBCC results for 'FctItem200508'. There are 8068694 rows in 146704 pages for object "FctItem200508". DBCC results for 'FctTender200802'. There are 0 rows in 0 pages for object "FctTender200802". DBCC results for 'FctItem200505'. There are 7070917 rows in 128563 pages for object "FctItem200505". DBCC results for 'FctInventory200608'. There are 33548346 rows in 459782 pages for object "FctInventory200608". DBCC results for 'FctTrans200508'. There are 8072020 rows in 106211 pages for object "FctTrans200508". DBCC results for 'FctItem200409'. There are 3518045 rows in 63965 pages for object "FctItem200409". DBCC results for 'FctInventory200609'. There are 33154325 rows in 423373 pages for object "FctInventory200609". DBCC results for 'FctPurchasesDetail200712'. There are 1601447 rows in 53383 pages for object "FctPurchasesDetail200712". DBCC results for 'FctTender200803'. There are 0 rows in 0 pages for object "FctTender200803". DBCC results for 'FctItem200410'. There are 4030031 rows in 73274 pages for object "FctItem200410". DBCC results for 'AggFctInventory200706'. There are 38251840 rows in 341536 pages for object "AggFctInventory200706". DBCC results for 'FctItem200411'. There are 4246191 rows in 77204 pages for object "FctItem200411". DBCC results for 'FctTender200804'. There are 0 rows in 0 pages for object "FctTender200804". DBCC results for 'FctItem200412'. There are 4669485 rows in 84900 pages for object "FctItem200412". DBCC results for 'FctTender200707'. There are 38975324 rows in 638940 pages for object "FctTender200707". DBCC results for 'DimScenario'. There are 2 rows in 1 pages for object "DimScenario". DBCC results for 'FctTender200805'. There are 0 rows in 0 pages for object "FctTender200805". DBCC results for 'FctTender200708'. There are 38188637 rows in 626044 pages for object "FctTender200708". DBCC results for 'AggFctCashierScorecard200801_old'. There are 732565 rows in 6106 pages for object "AggFctCashierScorecard200801_old". DBCC results for 'FctTender200512'. There are 34223755 rows in 561048 pages for object "FctTender200512". DBCC results for 'FctTrans200409'. There are 3518579 rows in 46298 pages for object "FctTrans200409". DBCC results for 'FctTender200806'. There are 0 rows in 0 pages for object "FctTender200806". DBCC results for 'FctTrans200410'. There are 4030716 rows in 53036 pages for object "FctTrans200410". DBCC results for 'AggFctInventory200708'. There are 39462282 rows in 352344 pages for object "AggFctInventory200708". DBCC results for 'FctPurchases200606'. There are 73648 rows in 7365 pages for object "FctPurchases200606". DBCC results for 'FctTender200709'. There are 36556657 rows in 599290 pages for object "FctTender200709". DBCC results for 'FctTender200511'. There are 33620449 rows in 551158 pages for object "FctTender200511". DBCC results for 'FctTrans200411'. There are 4247042 rows in 55883 pages for object "FctTrans200411". DBCC results for 'FctInventory'. There are 0 rows in 1 pages for object "FctInventory". DBCC results for 'FctTenderBridge200801'. There are 17369173 rows in 45116 pages for object "FctTenderBridge200801". DBCC results for 'FctTender200710'. There are 38549430 rows in 631958 pages for object "FctTender200710". DBCC results for 'FctTenderBridge200802'. There are 0 rows in 0 pages for object "FctTenderBridge200802". DBCC results for 'FctTender200510'. There are 34910026 rows in 572297 pages for object "FctTender200510". DBCC results for 'FctTrans200412'. There are 4670468 rows in 61454 pages for object "FctTrans200412". DBCC results for 'FctPurchases200605'. There are 75207 rows in 7521 pages for object "FctPurchases200605". DBCC results for 'vw_DimCashier'. There are 60954 rows in 3854 pages for object "vw_DimCashier". DBCC results for 'FctTenderBridge200803'. There are 0 rows in 0 pages for object "FctTenderBridge200803". DBCC results for 'AggFctInventory200702'. There are 32915438 rows in 293889 pages for object "AggFctInventory200702". DBCC results for 'FctTender200711'. There are 37127176 rows in 608643 pages for object "FctTender200711". DBCC results for 'FctTenderBridge200804'. There are 0 rows in 0 pages for object "FctTenderBridge200804". DBCC results for 'FctTender200509'. There are 34091198 rows in 558875 pages for object "FctTender200509". DBCC results for 'grand_general_upcs'. There are 2956 rows in 56 pages for object "grand_general_upcs". DBCC results for 'DimPromo'. There are 5608 rows in 110 pages for object "DimPromo". DBCC results for 'FctTenderBridge200805'. There are 0 rows in 0 pages for object "FctTenderBridge200805". DBCC results for 'FctPurchasesDetail200606'. There are 1540935 rows in 51365 pages for object "FctPurchasesDetail200606". DBCC results for 'FctInventory200701'. There are 35703489 rows in 476319 pages for object "FctInventory200701". DBCC results for 'FctTender200712'. There are 36607032 rows in 600116 pages for object "FctTender200712". DBCC results for 'FctTenderBridge200806'. There are 0 rows in 0 pages for object "FctTenderBridge200806". DBCC results for 'FctTenderBridge200512'. There are 22697922 rows in 58960 pages for object "FctTenderBridge200512". DBCC results for 'fcttrans200801_ORGINAL'. There are 15742397 rows in 243502 pages for object "fcttrans200801_ORGINAL". DBCC results for 'FctTenderBridge200511'. There are 22234576 rows in 57753 pages for object "FctTenderBridge200511". DBCC results for 'DimBusinessDate'. There are 2191 rows in 29 pages for object "DimBusinessDate". DBCC results for 'FctInventory200702'. There are 32931632 rows in 434210 pages for object "FctInventory200702". DBCC results for 'FctTenderBridge200707'. There are 26199605 rows in 68051 pages for object "FctTenderBridge200707". DBCC results for 'FctTrans200802'. There are 0 rows in 0 pages for object "FctTrans200802". DBCC results for 'FctTenderBridge200510'. There are 23028341 rows in 59816 pages for object "FctTenderBridge200510". DBCC results for 'FctPurchasesDetail200605'. There are 1498862 rows in 49963 pages for object "FctPurchasesDetail200605". DBCC results for 'FctTenderBridge200708'. There are 25724739 rows in 66819 pages for object "FctTenderBridge200708". DBCC results for 'FctTrans200803'. There are 0 rows in 0 pages for object "FctTrans200803". DBCC results for 'FctTenderBridge200509'. There are 22528117 rows in 58519 pages for object "FctTenderBridge200509". DBCC results for 'FctInventory200703'. There are 38252048 rows in 503846 pages for object "FctInventory200703". DBCC results for 'FctTenderBridge200709'. There are 24633845 rows in 63985 pages for object "FctTenderBridge200709". DBCC results for 'FctTrans200804'. There are 0 rows in 0 pages for object "FctTrans200804". DBCC results for 'vw_FctItemFctTender200612'. There are 55519368 rows in 1038161 pages for object "vw_FctItemFctTender200612". DBCC results for 'FctMarketBasket200608'. There are 13460138 rows in 128192 pages for object "FctMarketBasket200608". DBCC results for 'FctTenderBridge200710'. There are 26089474 rows in 67768 pages for object "FctTenderBridge200710". DBCC results for 'FctTrans200805'. There are 0 rows in 0 pages for object "FctTrans200805". DBCC results for 'vw_FctItemFctTender200609'. There are 56443335 rows in 1007583 pages for object "vw_FctItemFctTender200609". DBCC results for 'FctPurchasesDetail200604'. There are 1344523 rows in 44818 pages for object "FctPurchasesDetail200604". DBCC results for 'FctTender'. There are 0 rows in 3 pages for object "FctTender". DBCC results for 'FctItem200701'. There are 56257582 rows in 1221460 pages for object "FctItem200701". DBCC results for 'FctMarketBasket200607'. There are 13176166 rows in 125488 pages for object "FctMarketBasket200607". DBCC results for 'FctTenderBridge200711'. There are 25288645 rows in 65686 pages for object "FctTenderBridge200711". DBCC results for 'FctTrans200806'. There are 0 rows in 0 pages for object "FctTrans200806". DBCC results for 'vw_FctItemFctTender200608'. Indexed view check failed for indexed view 'vw_FctItemFctTender200608' (object ID 1037246750) due to internal query error 5242, severity 16, state 1. Refer to Books Online for more information on this error. This does not necessarily represent an integrity issue with the data in this database. However, this view will not be processed further. There are 62321634 rows in 1112544 pages for object "vw_FctItemFctTender200608". DBCC results for 'FctItem200702'. There are 54195455 rows in 1188990 pages for object "FctItem200702". DBCC results for 'FctMarketBasket200606'. There are 12736966 rows in 121309 pages for object "FctMarketBasket200606". DBCC results for 'FctTenderBridge200712'. There are 24916963 rows in 64721 pages for object "FctTenderBridge200712". DBCC results for 'vw_FctItemFctTender200607'. There are 63641670 rows in 1097729 pages for object "vw_FctItemFctTender200607". DBCC results for 'FctItem200703'. There are 62038035 rows in 1346826 pages for object "FctItem200703". DBCC results for 'FctMarketBasket200605'. There are 12201466 rows in 116209 pages for object "FctMarketBasket200605". DBCC results for 'FctTrans200707'. There are 43190400 rows in 668168 pages for object "FctTrans200707". DBCC results for 'vw_FctItemFctTender200606'. Indexed view check failed for indexed view 'vw_FctItemFctTender200606' (object ID 1069246864) due to internal query error 5242, severity 16, state 1. Refer to Books Online for more information on this error. This does not necessarily represent an integrity issue with the data in this database. However, this view will not be processed further. There are 60310390 rows in 1040058 pages for object "vw_FctItemFctTender200606". DBCC results for 'FctPurchases200604'. There are 67935 rows in 6794 pages for object "FctPurchases200604". DBCC results for 'FctMarketBasket200604'. There are 11140002 rows in 106099 pages for object "FctMarketBasket200604". DBCC results for 'FctTrans200708'. There are 43396612 rows in 671294 pages for object "FctTrans200708". DBCC results for 'vw_FctItemFctTender200605'. Msg 8908, Level 16, State 1, Server KNXPNAETLSQL2005, Line 1 Indexed view 'vw_FctItemFctTender200605' (object ID 1085246921) does not contain all rows that the view definition produces. Refer to Books Online for more information on this error. This does not necessarily represent an integrity issue with the data in this database. There are 55705251 rows in 960564 pages for object "vw_FctItemFctTender200605". CHECKDB found 0 allocation errors and 1 consistency errors in table 'vw_FctItemFctTender200605' (object ID 1085246921). DBCC results for 'FCTInventoryWaste200509'. There are 0 rows in 0 pages for object "FCTInventoryWaste200509". DBCC results for 'FctMarketBasket200603'. There are 11861292 rows in 112968 pages for object "FctMarketBasket200603". DBCC results for 'FctTrans200709'. There are 33951188 rows in 524909 pages for object "FctTrans200709". DBCC results for 'vw_FctItemFctTender200604'. Msg 8907, Level 16, State 1, Server KNXPNAETLSQL2005, Line 1 Indexed view 'vw_FctItemFctTender200604' (object ID 1101246978) contains rows not produced by the view definition. Refer to Books Online for more information on this error. This does not necessarily represent an integrity issue with the data in this database. There are 55331833 rows in 959978 pages for object "vw_FctItemFctTender200604". CHECKDB found 0 allocation errors and 1 consistency errors in table 'vw_FctItemFctTender200604' (object ID 1101246978). DBCC results for 'FCTInventoryWaste200510'. There are 0 rows in 0 pages for object "FCTInventoryWaste200510". DBCC results for 'DimPriceBookPromo'. There are 118230 rows in 1104 pages for object "DimPriceBookPromo". DBCC results for 'FctMarketBasket200602'. There are 9858833 rows in 93897 pages for object "FctMarketBasket200602". DBCC results for 'FctTrans200710'. There are 33485504 rows in 517574 pages for object "FctTrans200710". DBCC results for 'vw_FctItemFctTender200603'. Msg 8908, Level 16, State 1, Server KNXPNAETLSQL2005, Line 1 Indexed view 'vw_FctItemFctTender200603' (object ID 1117247035) does not contain all rows that the view definition produces. Refer to Books Online for more information on this error. This does not necessarily represent an integrity issue with the data in this database. There are 56649889 rows in 976726 pages for object "vw_FctItemFctTender200603". CHECKDB found 0 allocation errors and 1 consistency errors in table 'vw_FctItemFctTender200603' (object ID 1117247035). DBCC results for 'FCTInventoryWaste200511'. There are 0 rows in 0 pages for object "FCTInventoryWaste200511". DBCC results for 'vw_DimItemAccount'. There are 10 rows in 1 pages for object "vw_DimItemAccount". DBCC results for 'FctPurchases200603'. There are 73862 rows in 7387 pages for object "FctPurchases200603". DBCC results for 'FctPurchases200701'. There are 81741 rows in 8175 pages for object "FctPurchases200701". DBCC results for 'FctMarketBasket200601'. There are 10775055 rows in 102623 pages for object "FctMarketBasket200601". DBCC results for 'FctTrans200711'. There are 32895965 rows in 508494 pages for object "FctTrans200711". DBCC results for 'vw_FctItemFctTender200602'. There are 47477589 rows in 818580 pages for object "vw_FctItemFctTender200602". DBCC results for 'FCTInventoryWaste200512'. There are 0 rows in 0 pages for object "FCTInventoryWaste200512". DBCC results for 'FctInventoryOverShort200704'. There are 22221 rows in 2332 pages for object "FctInventoryOverShort200704". DBCC results for 'FctTrans200712'. There are 32819820 rows in 507497 pages for object "FctTrans200712". DBCC results for 'vw_FctItemFctTender200601'. Msg 8907, Level 16, State 1, Server KNXPNAETLSQL2005, Line 1 Indexed view 'vw_FctItemFctTender200601' (object ID 1149247149) contains rows not produced by the view definition. Refer to Books Online for more information on this error. This does not necessarily represent an integrity issue with the data in this database. Msg 8908, Level 16, State 1, Server KNXPNAETLSQL2005, Line 1 Indexed view 'vw_FctItemFctTender200601' (object ID 1149247149) does not contain all rows that the view definition produces. Refer to Books Online for more information on this error. This does not necessarily represent an integrity issue with the data in this database. There are 50796714 rows in 875806 pages for object "vw_FctItemFctTender200601". CHECKDB found 0 allocation errors and 2 consistency errors in table 'vw_FctItemFctTender200601' (object ID 1149247149). DBCC results for 'FCTInventoryWaste200601'. There are 13947 rows in 1163 pages for object "FCTInventoryWaste200601". DBCC results for 'FctInventoryOverShort200705'. There are 25592 rows in 2432 pages for object "FctInventoryOverShort200705". DBCC results for 'vw_FctItemFctTender200512'. Msg 8908, Level 16, State 1, Server KNXPNAETLSQL2005, Line 1 Indexed view 'vw_FctItemFctTender200512' (object ID 1165247206) does not contain all rows that the view definition produces. Refer to Books Online for more information on this error. This does not necessarily represent an integrity issue with the data in this database. There are 54301932 rows in 936241 pages for object "vw_FctItemFctTender200512". CHECKDB found 0 allocation errors and 1 consistency errors in table 'vw_FctItemFctTender200512' (object ID 1165247206). DBCC results for 'FCTInventoryWaste200602'. There are 12009 rows in 1001 pages for object "FCTInventoryWaste200602". DBCC results for 'vw_DimScenario'. There are 2 rows in 1 pages for object "vw_DimScenario". DBCC results for 'FctPurchasesDetail200603'. There are 1475591 rows in 49187 pages for object "FctPurchasesDetail200603". DBCC results for 'FctInventoryOverShort200706'. There are 27514 rows in 2620 pages for object "FctInventoryOverShort200706". DBCC results for 'FctPurchases200702'. There are 76123 rows in 7613 pages for object "FctPurchases200702". DBCC results for 'vw_FctItemFctTender200511'. Indexed view check failed for indexed view 'vw_FctItemFctTender200511' (object ID 1181247263) due to internal query error 5242, severity 16, state 1. Refer to Books Online for more information on this error. This does not necessarily represent an integrity issue with the data in this database. However, this view will not be processed further. There are 52659454 rows in 907922 pages for object "vw_FctItemFctTender200511". DBCC results for 'FCTInventoryWaste200603'. There are 13039 rows in 1087 pages for object "FCTInventoryWaste200603". DBCC results for 'vw_DimTransAccount'. There are 23 rows in 1 pages for object "vw_DimTransAccount". DBCC results for 'vw_FctItemFctTender200510'. There are 54368234 rows in 937384 pages for object "vw_FctItemFctTender200510". DBCC results for 'FCTInventoryWaste200604'. There are 11613 rows in 968 pages for object "FCTInventoryWaste200604". DBCC results for 'AggFctInventory200609'. There are 30397051 rows in 241247 pages for object "AggFctInventory200609". DBCC results for 'FCTInventoryWaste200605'. There are 12187 rows in 1016 pages for object "FCTInventoryWaste200605". DBCC results for 'AggFctInventory200704'. There are 37649918 rows in 336162 pages for object "AggFctInventory200704". DBCC results for 'FctPurchasesDetail200602'. There are 1254092 rows in 41804 pages for object "FctPurchasesDetail200602". DBCC results for 'FctPurchases200703'. There are 85893 rows in 8590 pages for object "FctPurchases200703". DBCC results for 'FCTInventoryWaste200606'. There are 11818 rows in 985 pages for object "FCTInventoryWaste200606". DBCC results for 'FctTenderBridge'. There are 0 rows in 1 pages for object "FctTenderBridge". DBCC results for 'FCTInventoryWaste200607'. There are 12518 rows in 1044 pages for object "FCTInventoryWaste200607". DBCC results for 'FctItem200601'. There are 52533515 rows in 1140810 pages for object "FctItem200601". DBCC results for 'FctBudget'. There are 17450650 rows in 248677 pages for object "FctBudget". DBCC results for 'FCTInventoryWaste200608'. There are 13150 rows in 1096 pages for object "FCTInventoryWaste200608". DBCC results for 'FctPurchases200602'. There are 64427 rows in 6443 pages for object "FctPurchases200602". DBCC results for 'FctPurchasesDetail200701'. There are 1534839 rows in 51162 pages for object "FctPurchasesDetail200701". DBCC results for 'FctItem200606'. There are 62724410 rows in 1391801 pages for object "FctItem200606". DBCC results for 'vw_FctItem200612'. There are 52130481 rows in 1133272 pages for object "vw_FctItem200612". DBCC results for 'FCTInventoryWaste200609'. There are 12481 rows in 1041 pages for object "FCTInventoryWaste200609". DBCC results for 'AggFctInventory200610'. There are 34001457 rows in 269853 pages for object "AggFctInventory200610". DBCC results for 'FctTrans200606'. There are 38400926 rows in 640654 pages for object "FctTrans200606". DBCC results for 'FCTInventoryWaste200610'. There are 13520 rows in 1127 pages for object "FCTInventoryWaste200610". DBCC results for 'vw_FctItemFctTender200610'. Indexed view check failed for indexed view 'vw_FctItemFctTender200610' (object ID 1305771709) due to internal query error 5242, severity 16, state 1. Refer to Books Online for more information on this error. This does not necessarily represent an integrity issue with the data in this database. However, this view will not be processed further. There are 57939653 rows in 1033756 pages for object "vw_FctItemFctTender200610". DBCC results for 'AggFctInventory200612'. There are 35384669 rows in 280831 pages for object "AggFctInventory200612". DBCC results for 'FCTInventoryWaste200611'. There are 13381 rows in 1116 pages for object "FCTInventoryWaste200611". DBCC results for 'FctPurchasesDetail200601'. There are 1338455 rows in 44616 pages for object "FctPurchasesDetail200601". DBCC results for 'vw_DimPriceBookPromo'. There are 118229 rows in 1895 pages for object "vw_DimPriceBookPromo". DBCC results for 'FctPurchasesDetail200702'. There are 1488946 rows in 49632 pages for object "FctPurchasesDetail200702". DBCC results for 'vw_TicketInternalKey200612'. There are 22346428 rows in 69265 pages for object "vw_TicketInternalKey200612". DBCC results for 'vw_FctBudget'. There are 7888015 rows in 144737 pages for object "vw_FctBudget". DBCC results for 'FCTInventoryWaste200612'. There are 15684 rows in 1307 pages for object "FCTInventoryWaste200612". DBCC results for 'vw_TicketInternalKey200609'. There are 22601520 rows in 69974 pages for object "vw_TicketInternalKey200609". DBCC results for 'FCTInventoryWaste200701'. There are 17266 rows in 1439 pages for object "FCTInventoryWaste200701". DBCC results for 'vw_TicketInternalKey200608'. There are 24686521 rows in 76429 pages for object "vw_TicketInternalKey200608". DBCC results for 'FCTInventoryWaste200702'. There are 14803 rows in 1234 pages for object "FCTInventoryWaste200702". DBCC results for 'FctPurchasesDetail200512'. There are 1434370 rows in 47813 pages for object "FctPurchasesDetail200512". DBCC results for 'FctPurchasesDetail200703'. There are 1650558 rows in 55020 pages for object "FctPurchasesDetail200703". DBCC results for 'vw_TicketInternalKey200607'. Msg 8907, Level 16, State 1, Server KNXPNAETLSQL2005, Line 1 Indexed view 'vw_TicketInternalKey200607' (object ID 1369771937) contains rows not produced by the view definition. Refer to Books Online for more information on this error. This does not necessarily represent an integrity issue with the data in this database. There are 24698391 rows in 76466 pages for object "vw_TicketInternalKey200607". CHECKDB found 0 allocation errors and 1 consistency errors in table 'vw_TicketInternalKey200607' (object ID 1369771937). DBCC results for 'FCTInventoryWaste200703'. There are 16608 rows in 1384 pages for object "FCTInventoryWaste200703". DBCC results for 'vw_TicketInternalKey200606'. There are 23769033 rows in 73589 pages for object "vw_TicketInternalKey200606". DBCC results for 'Staging_FOCUSITEMS_ByVendor'. There are 21777 rows in 921 pages for object "Staging_FOCUSITEMS_ByVendor". DBCC results for 'AggFctInventory200802'. There are 0 rows in 0 pages for object "AggFctInventory200802". DBCC results for 'AggFctInventory200607'. There are 33035231 rows in 262184 pages for object "AggFctInventory200607". DBCC results for 'FCTInventoryWaste200704'. There are 16125 rows in 1344 pages for object "FCTInventoryWaste200704". DBCC results for 'vw_TicketInternalKey200605'. There are 22425315 rows in 69429 pages for object "vw_TicketInternalKey200605". DBCC results for 'AggFctInventory200803'. There are 0 rows in 0 pages for object "AggFctInventory200803". DBCC results for 'FCTInventoryWaste200705'. There are 16463 rows in 1372 pages for object "FCTInventoryWaste200705". DBCC results for 'FctPurchases200512'. There are 73225 rows in 7323 pages for object "FctPurchases200512". DBCC results for 'FctMarketBasket200701'. There are 12107517 rows in 115310 pages for object "FctMarketBasket200701". DBCC results for 'vw_TicketInternalKey200604'. There are 22166578 rows in 68937 pages for object "vw_TicketInternalKey200604". DBCC results for 'AggFctInventory200804'. There are 0 rows in 0 pages for object "AggFctInventory200804". DBCC results for 'AggFctInventory200608'. There are 33151524 rows in 263107 pages for object "AggFctInventory200608". DBCC results for 'FCTInventoryWaste200706'. There are 16117 rows in 1344 pages for object "FCTInventoryWaste200706". DBCC results for 'FctMarketBasket200702'. There are 11214976 rows in 106810 pages for object "FctMarketBasket200702". DBCC results for 'vw_TicketInternalKey200603'. There are 22886943 rows in 70858 pages for object "vw_TicketInternalKey200603". DBCC results for 'AggFctInventory200805'. There are 0 rows in 0 pages for object "AggFctInventory200805". DBCC results for 'FctInventoryWasteDetail200509'. There are 0 rows in 0 pages for object "FctInventoryWasteDetail200509". DBCC results for 'FctMarketBasket200703'. There are 12761633 rows in 121540 pages for object "FctMarketBasket200703". DBCC results for 'FctInventory200704'. There are 37695453 rows in 523551 pages for object "FctInventory200704". DBCC results for 'vw_TicketInternalKey200602'. There are 19189009 rows in 59409 pages for object "vw_TicketInternalKey200602". DBCC results for 'FctItem200608'. There are 64855844 rows in 1457417 pages for object "FctItem200608". DBCC results for 'AggFctInventory200806'. There are 0 rows in 0 pages for object "AggFctInventory200806". DBCC results for 'FctInventoryWasteDetail200510'. There are 0 rows in 0 pages for object "FctInventoryWasteDetail200510". DBCC results for 'FctPurchases200511'. There are 70537 rows in 7054 pages for object "FctPurchases200511". DBCC results for 'FctTender200701'. There are 34225526 rows in 561075 pages for object "FctTender200701". DBCC results for 'vw_TicketInternalKey200601'. There are 20660832 rows in 63966 pages for object "vw_TicketInternalKey200601". DBCC results for 'FctTrans200608'. There are 39789289 rows in 653515 pages for object "FctTrans200608". DBCC results for 'vw_FctTransFctTender200609'. There are 23083511 rows in 378604 pages for object "vw_FctTransFctTender200609". DBCC results for 'FctInventory200801'. There are 29905699 rows in 523773 pages for object "FctInventory200801". DBCC results for 'FctInventoryWasteDetail200511'. There are 0 rows in 0 pages for object "FctInventoryWasteDetail200511". DBCC results for 'DimTill'. There are 16 rows in 1 pages for object "DimTill". DBCC results for 'FctInventory200705'. There are 38970106 rows in 541256 pages for object "FctInventory200705". DBCC results for 'vw_TicketInternalKey200512'. There are 21779722 rows in 67430 pages for object "vw_TicketInternalKey200512". DBCC results for 'vw_FctTransFctTender200608'. There are 25207905 rows in 435214 pages for object "vw_FctTransFctTender200608". DBCC results for 'vw_FctTransFctTender200610'. There are 23766888 rows in 389807 pages for object "vw_FctTransFctTender200610". DBCC results for 'FctInventoryWasteDetail200512'. There are 0 rows in 0 pages for object "FctInventoryWasteDetail200512". DBCC results for 'FctTender200702'. There are 32671979 rows in 535607 pages for object "FctTender200702". DBCC results for 'vw_TicketInternalKey200511'. There are 21311948 rows in 65982 pages for object "vw_TicketInternalKey200511". DBCC results for 'vw_FctTransFctTender200607'. There are 25234186 rows in 442871 pages for object "vw_FctTransFctTender200607". DBCC results for 'FctInventory200802'. There are 0 rows in 0 pages for object "FctInventory200802". DBCC results for 'AggFctInventoryReview'. There are 958840 rows in 7611 pages for object "AggFctInventoryReview". DBCC results for 'FctInventoryWasteDetail200601'. There are 128704 rows in 10726 pages for object "FctInventoryWasteDetail200601". DBCC results for 'FctPurchasesDetail200511'. There are 1409930 rows in 46998 pages for object "FctPurchasesDetail200511". DBCC results for 'FctInventory200706'. There are 38252109 rows in 531284 pages for object "FctInventory200706". DBCC results for 'vw_TicketInternalKey200510'. There are 22062804 rows in 68306 pages for object "vw_TicketInternalKey200510". DBCC results for 'DimCashierScoreCardMetric_01162007'. There are 46 rows in 16 pages for object "DimCashierScoreCardMetric_01162007". DBCC results for 'AggFctInventory200711'. There are 39850504 rows in 355810 pages for object "AggFctInventory200711". DBCC results for 'FctInventoryWasteDetail200602'. There are 112303 rows in 9359 pages for object "FctInventoryWasteDetail200602". DBCC results for 'FctTender200703'. There are 36122249 rows in 592169 pages for object "FctTender200703". DBCC results for 'vw_TicketInternalKey200509'. There are 21589065 rows in 66840 pages for object "vw_TicketInternalKey200509". DBCC results for 'AggFctInventory200801'. There are 29441137 rows in 262868 pages for object "AggFctInventory200801". DBCC results for 'vw_FctTransFctTender200606'. There are 24283086 rows in 426176 pages for object "vw_FctTransFctTender200606". DBCC results for 'DimCashierScoreCardMetric_orig'. There are 44 rows in 15 pages for object "DimCashierScoreCardMetric_orig". DBCC results for 'FctInventory200803'. There are 0 rows in 0 pages for object "FctInventory200803". DBCC results for 'FctInventoryWasteDetail200603'. There are 127779 rows in 10649 pages for object "FctInventoryWasteDetail200603". DBCC results for 'FctItem200610'. There are 60162067 rows in 1305938 pages for object "FctItem200610". DBCC results for 'FctItem'. There are 0 rows in 1 pages for object "FctItem". DBCC results for 'FctInventoryDetailOverShort200704'. There are 1484083 rows in 46481 pages for object "FctInventoryDetailOverShort200704". DBCC results for 'vw_FctTransFctTender200605'. Msg 8907, Level 16, State 1, Server KNXPNAETLSQL2005, Line 1 Indexed view 'vw_FctTransFctTender200605' (object ID 1549248574) contains rows not produced by the view definition. Refer to Books Online for more information on this error. This does not necessarily represent an integrity issue with the data in this database. Msg 8908, Level 16, State 1, Server KNXPNAETLSQL2005, Line 1 Indexed view 'vw_FctTransFctTender200605' (object ID 1549248574) does not contain all rows that the view definition produces. Refer to Books Online for more information on this error. This does not necessarily represent an integrity issue with the data in this database. There are 22888622 rows in 401040 pages for object "vw_FctTransFctTender200605". CHECKDB found 0 allocation errors and 2 consistency errors in table 'vw_FctTransFctTender200605' (object ID 1549248574). DBCC results for 'FctTrans200801'. There are 22806016 rows in 352545 pages for object "FctTrans200801". DBCC results for 'FctInventoryWasteDetail200604'. There are 115408 rows in 9618 pages for object "FctInventoryWasteDetail200604". DBCC results for 'FctPurchasesDetail200510'. There are 1368026 rows in 45601 pages for object "FctPurchasesDetail200510". DBCC results for 'FctItem200611'. There are 58588889 rows in 1271737 pages for object "FctItem200611". DBCC results for 'FctTenderBridge200701'. There are 23067465 rows in 59916 pages for object "FctTenderBridge200701". DBCC results for 'FctInventoryDetailOverShort200705'. There are 1517066 rows in 48130 pages for object "FctInventoryDetailOverShort200705". DBCC results for 'vw_FctTransFctTender200604'. There are 22618689 rows in 396964 pages for object "vw_FctTransFctTender200604". DBCC results for 'FctItem200801'. There are 41208843 rows in 894225 pages for object "FctItem200801". DBCC results for 'FctInventory200804'. There are 0 rows in 0 pages for object "FctInventory200804". DBCC results for 'FctInventoryWasteDetail200605'. There are 123662 rows in 10306 pages for object "FctInventoryWasteDetail200605". DBCC results for 'FctItem200612'. There are 58947898 rows in 1279917 pages for object "FctItem200612". DBCC results for 'FctTenderBridge200702'. There are 21954795 rows in 57026 pages for object "FctTenderBridge200702". DBCC results for 'FctInventoryDetailOverShort200706'. There are 1340892 rows in 43708 pages for object "FctInventoryDetailOverShort200706". DBCC results for 'FctInventory200707'. There are 39662660 rows in 561343 pages for object "FctInventory200707". DBCC results for 'vw_FctTransFctTender200603'. There are 23344796 rows in 409706 pages for object "vw_FctTransFctTender200603". DBCC results for 'FctInventoryWasteDetail200606'. There are 115162 rows in 9597 pages for object "FctInventoryWasteDetail200606". DBCC results for 'FctMarketBasket200610'. There are 12762686 rows in 121550 pages for object "FctMarketBasket200610". DBCC results for 'FctTenderBridge200703'. There are 24276224 rows in 63057 pages for object "FctTenderBridge200703". DBCC results for 'vw_FctTransFctTender200602'. There are 19578204 rows in 343603 pages for object "vw_FctTransFctTender200602". DBCC results for 'FctInventory200805'. There are 0 rows in 0 pages for object "FctInventory200805". DBCC results for 'FctInventoryWasteDetail200607'. There are 122175 rows in 10182 pages for object "FctInventoryWasteDetail200607". DBCC results for 'FctPurchases200510'. There are 70660 rows in 7066 pages for object "FctPurchases200510". DBCC results for 'FctMarketBasket200611'. There are 13561902 rows in 129161 pages for object "FctMarketBasket200611". DBCC results for 'FctTrans200701'. There are 36465522 rows in 564690 pages for object "FctTrans200701". DBCC results for 'FctInventory200708'. There are 39701544 rows in 616017 pages for object "FctInventory200708". DBCC results for 'vw_FctTransFctTender200601'. Msg 8907, Level 16, State 1, Server KNXPNAETLSQL2005, Line 1 Indexed view 'vw_FctTransFctTender200601' (object ID 1613248802) contains rows not produced by the view definition. Refer to Books Online for more information on this error. This does not necessarily represent an integrity issue with the data in this database. There are 21061710 rows in 369635 pages for object "vw_FctTransFctTender200601". CHECKDB found 0 allocation errors and 1 consistency errors in table 'vw_FctTransFctTender200601' (object ID 1613248802). DBCC results for 'FctInventoryWasteDetail200608'. There are 121127 rows in 10094 pages for object "FctInventoryWasteDetail200608". DBCC results for 'FctMarketBasket200612'. There are 12860503 rows in 122481 pages for object "FctMarketBasket200612". DBCC results for 'FctTrans200702'. There are 33238975 rows in 514737 pages for object "FctTrans200702". DBCC results for 'AggFctCashierScoreCard200701'. There are 1434201 rows in 11952 pages for object "AggFctCashierScoreCard200701". DBCC results for 'vw_FctTransFctTender200512'. Msg 8908, Level 16, State 1, Server KNXPNAETLSQL2005, Line 1 Indexed view 'vw_FctTransFctTender200512' (object ID 1629248859) does not contain all rows that the view definition produces. Refer to Books Online for more information on this error. This does not necessarily represent an integrity issue with the data in this database. There are 22210120 rows in 389795 pages for object "vw_FctTransFctTender200512". CHECKDB found 0 allocation errors and 1 consistency errors in table 'vw_FctTransFctTender200512' (object ID 1629248859). DBCC results for 'FctInventory200806'. There are 0 rows in 0 pages for object "FctInventory200806". DBCC results for 'FctInventoryWasteDetail200609'. There are 115143 rows in 9596 pages for object "FctInventoryWasteDetail200609". DBCC results for 'FctInventory200610'. There are 34233332 rows in 461211 pages for object "FctInventory200610". DBCC results for 'FctTrans200703'. There are 39713913 rows in 614538 pages for object "FctTrans200703". DBCC results for 'FctItem200704'. There are 60365747 rows in 1310370 pages for object "FctItem200704". DBCC results for 'AggFctCashierScoreCard200702'. There are 1214541 rows in 10122 pages for object "AggFctCashierScoreCard200702". DBCC results for 'FctInventory200709'. There are 38675506 rows in 545787 pages for object "FctInventory200709". DBCC results for 'vw_FctTransFctTender200511'. Msg 8908, Level 16, State 1, Server KNXPNAETLSQL2005, Line 1 Indexed view 'vw_FctTransFctTender200511' (object ID 1645248916) does not contain all rows that the view definition produces. Refer to Books Online for more information on this error. This does not necessarily represent an integrity issue with the data in this database. There are 21730576 rows in 381381 pages for object "vw_FctTransFctTender200511". CHECKDB found 0 allocation errors and 1 consistency errors in table 'vw_FctTransFctTender200511' (object ID 1645248916). DBCC results for 'FctInventoryWasteDetail200610'. There are 125323 rows in 10444 pages for object "FctInventoryWasteDetail200610". DBCC results for 'FctPurchases200509'. There are 72751 rows in 7276 pages for object "FctPurchases200509". DBCC results for 'FctItem200705'. There are 65959516 rows in 1445243 pages for object "FctItem200705". DBCC results for 'AggFctCashierScoreCard200703'. There are 1406685 rows in 11723 pages for object "AggFctCashierScoreCard200703". DBCC results for 'vw_FctTransFctTender200510'. Msg 8908, Level 16, State 1, Server KNXPNAETLSQL2005, Line 1 Indexed view 'vw_FctTransFctTender200510' (object ID 1661248973) does not contain all rows that the view definition produces. Refer to Books Online for more information on this error. This does not necessarily represent an integrity issue with the data in this database. There are 22504065 rows in 394958 pages for object "vw_FctTransFctTender200510". CHECKDB found 0 allocation errors and 1 consistency errors in table 'vw_FctTransFctTender200510' (object ID 1661248973). DBCC results for 'FctInventoryDetailOverShort200801'. There are 1040806 rows in 24007 pages for object "FctInventoryDetailOverShort200801". DBCC results for 'FctMarketBasketFuel200612'. There are 6121409 rows in 65822 pages for object "FctMarketBasketFuel200612". DBCC results for 'AggFctInventory200707'. There are 39662300 rows in 354130 pages for object "AggFctInventory200707". DBCC results for 'FctInventoryWasteDetail200611'. There are 122336 rows in 10195 pages for object "FctInventoryWasteDetail200611". DBCC results for 'FctInventory200611'. There are 33667100 rows in 438313 pages for object "FctInventory200611". DBCC results for 'FctItem200706'. There are 67926976 rows in 1474350 pages for object "FctItem200706". DBCC results for 'AggFctCashierScoreCard200704'. There are 2087657 rows in 17398 pages for object "AggFctCashierScoreCard200704". DBCC results for 'TempMTDDailyMCheckDate'. There are 16359 rows in 46 pages for object "TempMTDDailyMCheckDate". DBCC results for 'FctInventory200710'. There are 40550644 rows in 574700 pages for object "FctInventory200710". DBCC results for 'vw_FctTransFctTender200509'. There are 22017622 rows in 386422 pages for object "vw_FctTransFctTender200509". DBCC results for 'FctInventoryDetailOverShort200802'. There are 0 rows in 0 pages for object "FctInventoryDetailOverShort200802". DBCC results for 'FctInventoryWasteDetail200612'. There are 178662 rows in 15465 pages for object "FctInventoryWasteDetail200612". DBCC results for 'FctMarketBasket200704'. There are 12611156 rows in 120107 pages for object "FctMarketBasket200704". DBCC results for 'AggFctCashierScoreCard200705'. There are 1442440 rows in 12021 pages for object "AggFctCashierScoreCard200705". DBCC results for 'AggFctInventory200701'. There are 35666434 rows in 318452 pages for object "AggFctInventory200701". DBCC results for 'TempMTDDailyCheck'. There are 605 rows in 5 pages for object "TempMTDDailyCheck". DBCC results for 'FctInventoryDetailOverShort200803'. There are 0 rows in 0 pages for object "FctInventoryDetai
Here's a quick and dirty example of a legitimate bug in SQL Server.I've seen other examples, but they were all very complex, some eveninvolving cursors and such. This one will produce the error with just13 lines.A police department has a database that contains, among other things,information about parking tickets given out by the officers. Here isthe database and some sample data:create table ParkingTickets (TicketDate datetime,IssuingOfficer int)insert into ParkingTickets values ('1/2/2005 12:31',1)insert into ParkingTickets values ('1/2/2005 14:20',1)insert into ParkingTickets values ('1/3/2005 12:05',1)insert into ParkingTickets values ('1/3/2005 12:22',2)insert into ParkingTickets values ('1/3/2005 14:01',2)insert into ParkingTickets values ('1/4/2005 10:12',2)insert into ParkingTickets values ('1/2/2005 12:10',3)insert into ParkingTickets values ('1/4/2005 12:36',3)So, as you can see, officer 1 gave out three tickets. Officer 2 gaveout three, etc. Management wants a report containing the followinginformation;the Hour of Day,the ID of the Issuing Officer,the number of tickets issued by the officer during this hour during theweek,and the average number of tickets issued by all officers during thishour during the weekSo, if the report is to cover 1/2/2005 through 1/5/2005, the reportwould look like this:selectdatepart(hh,TicketDate) as HourOfDay,IssuingOfficer,count(*) as TicketsIssuedByThisOfficer,TotalTicketsForThisHour_AllOfficers = (select convert(real, count(*))/3from ParkingTicketswhere datepart(hh,TicketDate) = datepart(hh,PT.TicketDate)and TicketDate between '1/2/2005' and '1/5/2005')from ParkingTickets PTwhere TicketDate between '1/2/2005' and '1/5/2005'group by IssuingOfficer, datepart(hh,TicketDate)order by HourOfDay, IssuingOfficerdrop table ParkingTicketsif you'll run that in Query Analyzer, you'll see that it works justfine and produces the expected output. However, if you delete thisline:count(*) as TicketsIssuedByThisOfficer,the query errors out. It's almost like magic. With the count(*)there, the query runs. Without it, the query fails. I can't see anyreason why deleting that line would produce an error. There aremultiple references to this on the microsoft kb, and many of them havehotfixes. But none of them seems to fix this particular instance ofthe bug - and like I said, this is the simplest incarnation that I'veseen.Christopher Secord
I have a sql databaseI run dbcc checkdb and get no errorsI go to backup the database in enterprise manager, and it won'trestore because it has internal consistency errorsI can go back to an older version of the databaseI run a particular procedure in our accounting software packageNever do I get errors when running dbcc checkdbSometimes I get the backup and restore problem, sometimes I don'tI am doing this on a test server with about 220 megs of RAMI am trying the dbcc checkdb ('dbname',REPAIR_REBUILD) commandAny other ideas?
We have a website which uses an embedded ReportViewer two 3 distinct reports on a W2k3 server running SQL Server 2005 with Reporting Services installed (Machine is: 4 Proc Dual Core Opteron 64).
When a user first hits the report everything loads fine, however, after you click on the "Next Page" arrow several times the user gets an "occurred on the report server. See the error log for more details. " error message. It is random, sometime it happens after two pages, sometimes it happens after 6. This happens on all three reports we have on our system.
All three reports use parameters, I am not sure what is going on. Included below is a copy of our log
<Header> <Product>Microsoft SQL Server Reporting Services Version 9.00.3042.00</Product> <Locale>en-US</Locale> <TimeZone>Pacific Daylight Time</TimeZone> <Path>C:Program FilesMicrosoft SQL ServerMSSQL.3Reporting ServicesLogFilesReportServer__03_21_2007_09_10_24.log</Path> <SystemName>XXX-CCDIVAR</SystemName> <OSName>Microsoft Windows NT 5.2.3790 Service Pack 1</OSName> <OSVersion>5.2.3790.65536</OSVersion> </Header> w3wp!webserver!a!3/21/2007-09:10:24:: i INFO: Reporting Web Server started w3wp!library!a!3/21/2007-09:10:25:: i INFO: Initializing ConnectionType to '0' as specified in Configuration file. w3wp!library!a!3/21/2007-09:10:25:: i INFO: Initializing IsSchedulingService to 'True' as specified in Configuration file. w3wp!library!a!3/21/2007-09:10:25:: i INFO: Initializing IsNotificationService to 'True' as specified in Configuration file. w3wp!library!a!3/21/2007-09:10:25:: i INFO: Initializing IsEventService to 'True' as specified in Configuration file. w3wp!library!a!3/21/2007-09:10:25:: i INFO: Initializing PollingInterval to '10' second(s) as specified in Configuration file. w3wp!library!a!3/21/2007-09:10:25:: i INFO: Initializing WindowsServiceUseFileShareStorage to 'False' as specified in Configuration file. w3wp!library!a!3/21/2007-09:10:25:: i INFO: Initializing MemoryLimit to '60' percent as specified in Configuration file. w3wp!library!a!3/21/2007-09:10:25:: i INFO: Initializing RecycleTime to '720' minute(s) as specified in Configuration file. w3wp!library!a!3/21/2007-09:10:25:: i INFO: Initializing MaximumMemoryLimit to '80' percent as specified in Configuration file. w3wp!library!a!3/21/2007-09:10:25:: i INFO: Initializing MaxAppDomainUnloadTime to '30' minute(s) as specified in Configuration file. w3wp!library!a!3/21/2007-09:10:25:: i INFO: Initializing MaxQueueThreads to '0' thread(s) as specified in Configuration file. w3wp!library!a!3/21/2007-09:10:25:: i INFO: Initializing IsWebServiceEnabled to 'True' as specified in Configuration file. w3wp!library!a!3/21/2007-09:10:25:: i INFO: Initializing MaxActiveReqForOneUser to '20' requests(s) as specified in Configuration file. w3wp!library!a!3/21/2007-09:10:25:: i INFO: Initializing MaxScheduleWait to '5' second(s) as specified in Configuration file. w3wp!library!a!3/21/2007-09:10:25:: i INFO: Initializing DatabaseQueryTimeout to '120' second(s) as specified in Configuration file. w3wp!library!a!3/21/2007-09:10:25:: i INFO: Initializing ProcessRecycleOptions to '0' as specified in Configuration file. w3wp!library!a!3/21/2007-09:10:25:: i INFO: Initializing RunningRequestsScavengerCycle to '60' second(s) as specified in Configuration file. w3wp!library!a!3/21/2007-09:10:25:: i INFO: Initializing RunningRequestsDbCycle to '60' second(s) as specified in Configuration file. w3wp!library!a!3/21/2007-09:10:25:: i INFO: Initializing RunningRequestsAge to '30' second(s) as specified in Configuration file. w3wp!library!a!3/21/2007-09:10:25:: i INFO: Initializing CleanupCycleMinutes to '10' minute(s) as specified in Configuration file. w3wp!library!a!3/21/2007-09:10:25:: i INFO: Initializing DailyCleanupMinuteOfDay to default value of '120' minutes since midnight because it was not specified in Configuration file. w3wp!library!a!3/21/2007-09:10:25:: i INFO: Initializing WatsonFlags to '1064' as specified in Configuration file. w3wp!library!a!3/21/2007-09:10:25:: i INFO: Initializing WatsonDumpOnExceptions to 'Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException,Microsoft.ReportingServices.Modeling.InternalModelingException' as specified in Configuration file. w3wp!library!a!3/21/2007-09:10:25:: i INFO: Initializing WatsonDumpExcludeIfContainsExceptions to 'System.Data.SqlClient.SqlException,System.Threading.ThreadAbortException' as specified in Configuration file. w3wp!library!a!3/21/2007-09:10:25:: i INFO: Initializing SecureConnectionLevel to '0' as specified in Configuration file. w3wp!library!a!3/21/2007-09:10:25:: i INFO: Initializing DisplayErrorLink to 'True' as specified in Configuration file. w3wp!library!a!3/21/2007-09:10:25:: i INFO: Initializing WebServiceUseFileShareStorage to 'False' as specified in Configuration file. w3wp!resourceutilities!a!3/21/2007-09:10:25:: i INFO: Reporting Services starting SKU: Standard w3wp!resourceutilities!a!3/21/2007-09:10:25:: i INFO: Evaluation copy: 0 days left w3wp!resourceutilities!a!3/21/2007-09:10:25:: i INFO: Running on 4 physical processors, 8 logical processors w3wp!runningjobs!a!3/21/2007-09:10:25:: i INFO: Database Cleanup (Web Service) timer enabled: Next Event: 600 seconds. Cycle: 600 seconds w3wp!runningjobs!a!3/21/2007-09:10:25:: i INFO: Running Requests Scavenger timer enabled: Next Event: 60 seconds. Cycle: 60 seconds w3wp!runningjobs!a!3/21/2007-09:10:25:: i INFO: Running Requests DB timer enabled: Next Event: 60 seconds. Cycle: 60 seconds w3wp!runningjobs!a!3/21/2007-09:10:25:: i INFO: Memory stats update timer enabled: Next Event: 60 seconds. Cycle: 60 seconds w3wp!library!5!03/21/2007-09:10:25:: i INFO: Catalog SQL Server Edition = Standard w3wp!library!1!03/21/2007-09:10:30:: i INFO: Call to RenderFirst( '/xxx Divested AR/Aging Report' ) w3wp!runningjobs!1!3/21/2007-09:10:30:: w WARN: Thread pool pressure. Using current thread for a work item.
w3wp!processing!6!3/21/2007-09:10:31:: e ERROR: Throwing Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: There is no data for the field at position 1., ; Info: Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: There is no data for the field at position 1.
w3wp!library!1!03/21/2007-09:10:32:: Using folder C:Program FilesMicrosoft SQL ServerMSSQL.3Reporting ServicesRSTempFiles for temporary files. w3wp!webserver!1!03/21/2007-09:10:33:: i INFO: Processed report. Report='/xxx Divested AR/Aging Report', Stream='' w3wp!library!1!03/21/2007-09:10:35:: i INFO: Call to RenderNext( '/xxx Divested AR/Aging Report' ) w3wp!cache!1!03/21/2007-09:10:35:: i INFO: Session live: /xxx Divested AR/Aging Report w3wp!webserver!1!03/21/2007-09:10:35:: i INFO: Processed report. Report='/xxx Divested AR/Aging Report', Stream='' w3wp!library!7!03/21/2007-09:10:37:: i INFO: Call to RenderNext( '/xxx Divested AR/Aging Report' ) w3wp!cache!7!03/21/2007-09:10:37:: i INFO: Session live: /xxx Divested AR/Aging Report w3wp!webserver!7!03/21/2007-09:10:37:: i INFO: Processed report. Report='/xxx Divested AR/Aging Report', Stream='' w3wp!library!9!03/21/2007-09:10:38:: i INFO: Call to RenderNext( '/xxx Divested AR/Aging Report' )
w3wp!library!9!03/21/2007-09:10:38:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details., un-named assertion fired for component processing; Info: Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details. w3wp!library!9!03/21/2007-09:10:40:: i INFO: Exception dumped to: C:Program FilesMicrosoft SQL ServerMSSQL.3Reporting ServicesLogFiles flags= ReferencedMemory, AllThreads, SendToWatson w3wp!webserver!9!03/21/2007-09:10:40:: e ERROR: Reporting Services error Microsoft.ReportingServices.Diagnostics.Utilities.RSException: An internal error occurred on the report server. See the error log for more details. ---> Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details. w3wp!library!5!03/21/2007-09:15:20:: i INFO: Call to RenderFirst( '/xxx Divested AR/Statements Report' ) w3wp!webserver!5!03/21/2007-09:15:21:: i INFO: Processed report. Report='/xxx Divested AR/Statements Report', Stream='' w3wp!library!6!03/21/2007-09:15:30:: i INFO: Call to RenderNext( '/xxx Divested AR/Statements Report' ) w3wp!cache!6!03/21/2007-09:15:31:: i INFO: Session live: /xxx Divested AR/Statements Report w3wp!webserver!8!03/21/2007-09:15:31:: i INFO: Processed report. Report='/xxx Divested AR/Statements Report', Stream='' w3wp!library!b!03/21/2007-09:15:56:: i INFO: Call to RenderFirst( '/xxx Divested AR/Statements Report' ) w3wp!webserver!b!03/21/2007-09:15:57:: i INFO: Processed report. Report='/xxx Divested AR/Statements Report', Stream='' w3wp!library!6!03/21/2007-09:16:04:: i INFO: Call to RenderFirst( '/xxx Divested AR/Statements Report' ) w3wp!webserver!6!03/21/2007-09:16:05:: i INFO: Processed report. Report='/xxx Divested AR/Statements Report', Stream='' w3wp!library!b!03/21/2007-09:16:14:: i INFO: Call to RenderFirst( '/xxx Divested AR/Statements Report' ) w3wp!processing!b!03/21/2007-09:16:15:: a ASSERT: Assertion failed! Call stack: Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RenderReport(IRenderingExtension renderer, DateTime executionTimeStamp, GetReportChunk getCompiledDefinitionCallback, ProcessingContext pc, RenderingContext rc, CreateReportChunk cacheDataCallback, Boolean& dataCached) Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RenderReport(DateTime executionTimeStamp, GetReportChunk getCompiledDefinitionCallback, ProcessingContext pc, RenderingContext rc) Microsoft.ReportingServices.Library.RSService.RenderAsLive(CatalogItemContext reportContext, ItemProperties properties, ParameterInfoCollection effectiveParameters, Guid reportId, ClientRequest session, String description, ReportSnapshot intermediateSnapshot, DataSourceInfoCollection thisReportDataSources, Boolean cachingRequested, Boolean isLinkedReport, Warning[]& warnings, ReportSnapshot& resultSnapshotData, DateTime& executionDateTime, RuntimeDataSourceInfoCollection& alldataSources, UserProfileState& usedUserProfile) Microsoft.ReportingServices.Library.RSService.RenderAsLiveOrSnapshot(CatalogItemContext reportContext, ClientRequest session, Warning[]& warnings, ParameterInfoCollection& effectiveParameters) Microsoft.ReportingServices.Library.RSService.RenderFirst(CatalogItemContext reportContext, ClientRequest session, Warning[]& warnings, ParameterInfoCollection& effectiveParameters, String[]& secondaryStreamNames) Microsoft.ReportingServices.Library.RenderFirstCancelableStep.Execute() Microsoft.ReportingServices.Diagnostics.CancelablePhaseBase.ExecuteWrapper() Microsoft.ReportingServices.Library.RenderFirstCancelableStep.RenderFirst(RSService rs, CatalogItemContext reportContext, ClientRequest session, JobType type, Warning[]& warnings, ParameterInfoCollection& effectiveParameters, String[]& secondaryStreamNames) Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderReport(HttpResponseStreamFactory streamFactory) Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.DoStreamedOperation(StreamedOperation operation) Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPageContent() Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPage() Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.ProcessRequest(HttpContext context) System.Web.HttpApplication+CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) System.Web.HttpApplication.ResumeSteps(Exception error) System.Web.HttpApplication.System.Web.IHttpAsyncHandler.BeginProcessRequest(HttpContext context, AsyncCallback cb, Object extraData) System.Web.HttpRuntime.ProcessRequestInternal(HttpWorkerRequest wr) System.Web.HttpRuntime.ProcessRequestNoDemand(HttpWorkerRequest wr) System.Web.Hosting.ISAPIRuntime.ProcessRequest(IntPtr ecb, Int32 iWRType)
w3wp!library!b!03/21/2007-09:16:15:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details., un-named assertion fired for component processing; Info: Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details. w3wp!library!b!03/21/2007-09:16:47:: i INFO: Exception dumped to: C:Program FilesMicrosoft SQL ServerMSSQL.3Reporting ServicesLogFiles flags= ReferencedMemory, AllThreads, SendToWatson w3wp!webserver!b!03/21/2007-09:16:47:: e ERROR: Reporting Services error Microsoft.ReportingServices.Diagnostics.Utilities.RSException: An internal error occurred on the report server. See the error log for more details. ---> Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details. w3wp!library!9!03/21/2007-09:16:50:: i INFO: Call to RenderFirst( '/xxx Divested AR/Statements Report' ) w3wp!webserver!9!03/21/2007-09:16:51:: i INFO: Processed report. Report='/xxx Divested AR/Statements Report', Stream='' w3wp!library!8!03/21/2007-09:17:00:: i INFO: Call to RenderNext( '/xxx Divested AR/Statements Report' ) w3wp!cache!8!03/21/2007-09:17:00:: i INFO: Session live: /xxx Divested AR/Statements Report w3wp!webserver!a!03/21/2007-09:17:00:: i INFO: Processed report. Report='/xxx Divested AR/Statements Report', Stream='' w3wp!library!b!03/21/2007-09:17:20:: i INFO: Call to RenderFirst( '/xxx Divested AR/Adjustments And Receipts Report' ) w3wp!runningjobs!b!3/21/2007-09:17:22:: w WARN: Thread pool pressure. Using current thread for a work item. w3wp!runningjobs!b!3/21/2007-09:17:26:: w WARN: Thread pool pressure. Using current thread for a work item. w3wp!processing!b!3/21/2007-09:17:26:: e ERROR: Throwing Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: There is no data for the field at position 1., ; Info: Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: There is no data for the field at position 1. w3wp!runningjobs!b!3/21/2007-09:17:26:: w WARN: Thread pool pressure. Using current thread for a work item. w3wp!processing!5!3/21/2007-09:17:26:: e ERROR: Throwing Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: There is no data for the field at position 1., ; Info: Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: There is no data for the field at position 1. w3wp!webserver!b!03/21/2007-09:17:31:: i INFO: Processed report. Report='/xxx Divested AR/Adjustments And Receipts Report', Stream='' w3wp!library!9!03/21/2007-09:17:38:: i INFO: Call to RenderFirst( '/xxx Divested AR/Statements Report' ) w3wp!webserver!9!03/21/2007-09:17:39:: i INFO: Processed report. Report='/xxx Divested AR/Statements Report', Stream='' w3wp!library!9!03/21/2007-09:17:46:: i INFO: Call to RenderNext( '/xxx Divested AR/Adjustments And Receipts Report' ) w3wp!cache!9!03/21/2007-09:17:47:: i INFO: Session live: /xxx Divested AR/Adjustments And Receipts Report w3wp!webserver!9!03/21/2007-09:17:47:: i INFO: Processed report. Report='/xxx Divested AR/Adjustments And Receipts Report', Stream='' w3wp!library!6!03/21/2007-09:17:48:: i INFO: Call to RenderNext( '/xxx Divested AR/Adjustments And Receipts Report' ) w3wp!cache!6!03/21/2007-09:17:49:: i INFO: Session live: /xxx Divested AR/Adjustments And Receipts Report w3wp!webserver!6!03/21/2007-09:17:49:: i INFO: Processed report. Report='/xxx Divested AR/Adjustments And Receipts Report', Stream='' w3wp!library!a!03/21/2007-09:17:50:: i INFO: Call to RenderNext( '/xxx Divested AR/Adjustments And Receipts Report' ) w3wp!processing!a!03/21/2007-09:17:50:: a ASSERT: Assertion failed! Call stack: Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RenderSnapshot(IRenderingExtension renderer, CreateReportChunk createChunkCallback, RenderingContext rc, GetResource getResourceCallback) Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RenderSnapshot(CreateReportChunk createChunkCallback, RenderingContext rc, GetResource getResourceCallback) Microsoft.ReportingServices.Library.RenderSnapshotAction.Render() Microsoft.ReportingServices.Library.RSService.RenderFromSessionNoCache(CatalogItemContext reportContext, ClientRequest session, RenderingResult& result) Microsoft.ReportingServices.Library.RSService.RenderFromSession(CatalogItemContext reportContext, ClientRequest session, Warning[]& warnings, ParameterInfoCollection& effectiveParameters) Microsoft.ReportingServices.Library.RSService.RenderNext(CatalogItemContext reportContext, ClientRequest session, Warning[]& warnings, ParameterInfoCollection& effecectiveParameters, String[]& secondaryStreamNames) Microsoft.ReportingServices.Library.RenderNextCancelableStep.Execute() Microsoft.ReportingServices.Diagnostics.CancelablePhaseBase.ExecuteWrapper() Microsoft.ReportingServices.Library.RenderNextCancelableStep.RenderNext(RSService rs, CatalogItemContext reportContext, ClientRequest session, JobType type, Warning[]& warnings, ParameterInfoCollection& effectiveParameters, String[]& secondaryStreamNames) Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderReport(HttpResponseStreamFactory streamFactory) Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.DoStreamedOperation(StreamedOperation operation) Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPageContent() Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPage() Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.ProcessRequest(HttpContext context) System.Web.HttpApplication+CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) System.Web.HttpApplication.ResumeSteps(Exception error) System.Web.HttpApplication.System.Web.IHttpAsyncHandler.BeginProcessRequest(HttpContext context, AsyncCallback cb, Object extraData) System.Web.HttpRuntime.ProcessRequestInternal(HttpWorkerRequest wr) System.Web.HttpRuntime.ProcessRequestNoDemand(HttpWorkerRequest wr) System.Web.Hosting.ISAPIRuntime.ProcessRequest(IntPtr ecb, Int32 iWRType)
w3wp!library!a!03/21/2007-09:17:50:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details., un-named assertion fired for component processing; Info: Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details. w3wp!library!1!03/21/2007-09:18:00:: i INFO: Call to RenderNext( '/xxx Divested AR/Statements Report' ) w3wp!webserver!7!03/21/2007-09:18:01:: i INFO: Processed report. Report='/xxx Divested AR/Statements Report', Stream='' w3wp!cache!1!03/21/2007-09:18:01:: i INFO: Session live: /xxx Divested AR/Statements Report w3wp!library!a!03/21/2007-09:18:22:: i INFO: Exception dumped to: C:Program FilesMicrosoft SQL ServerMSSQL.3Reporting ServicesLogFiles flags= ReferencedMemory, AllThreads, SendToWatson w3wp!webserver!a!03/21/2007-09:18:22:: e ERROR: Reporting Services error Microsoft.ReportingServices.Diagnostics.Utilities.RSException: An internal error occurred on the report server. See the error log for more details. ---> Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details. w3wp!library!5!03/21/2007-09:18:50:: i INFO: Call to RenderFirst( '/xxx Divested AR/Statements Report' ) w3wp!processing!5!03/21/2007-09:18:50:: a ASSERT: Assertion failed! Call stack: Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RenderReport(IRenderingExtension renderer, DateTime executionTimeStamp, GetReportChunk getCompiledDefinitionCallback, ProcessingContext pc, RenderingContext rc, CreateReportChunk cacheDataCallback, Boolean& dataCached) Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RenderReport(DateTime executionTimeStamp, GetReportChunk getCompiledDefinitionCallback, ProcessingContext pc, RenderingContext rc) Microsoft.ReportingServices.Library.RSService.RenderAsLive(CatalogItemContext reportContext, ItemProperties properties, ParameterInfoCollection effectiveParameters, Guid reportId, ClientRequest session, String description, ReportSnapshot intermediateSnapshot, DataSourceInfoCollection thisReportDataSources, Boolean cachingRequested, Boolean isLinkedReport, Warning[]& warnings, ReportSnapshot& resultSnapshotData, DateTime& executionDateTime, RuntimeDataSourceInfoCollection& alldataSources, UserProfileState& usedUserProfile) Microsoft.ReportingServices.Library.RSService.RenderAsLiveOrSnapshot(CatalogItemContext reportContext, ClientRequest session, Warning[]& warnings, ParameterInfoCollection& effectiveParameters) Microsoft.ReportingServices.Library.RSService.RenderFirst(CatalogItemContext reportContext, ClientRequest session, Warning[]& warnings, ParameterInfoCollection& effectiveParameters, String[]& secondaryStreamNames) Microsoft.ReportingServices.Library.RenderFirstCancelableStep.Execute() Microsoft.ReportingServices.Diagnostics.CancelablePhaseBase.ExecuteWrapper() Microsoft.ReportingServices.Library.RenderFirstCancelableStep.RenderFirst(RSService rs, CatalogItemContext reportContext, ClientRequest session, JobType type, Warning[]& warnings, ParameterInfoCollection& effectiveParameters, String[]& secondaryStreamNames) Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderReport(HttpResponseStreamFactory streamFactory) Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.DoStreamedOperation(StreamedOperation operation) Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPageContent() Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPage() Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.ProcessRequest(HttpContext context) System.Web.HttpApplication+CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) System.Web.HttpApplication.ResumeSteps(Exception error) System.Web.HttpApplication.System.Web.IHttpAsyncHandler.BeginProcessRequest(HttpContext context, AsyncCallback cb, Object extraData) System.Web.HttpRuntime.ProcessRequestInternal(HttpWorkerRequest wr) System.Web.HttpRuntime.ProcessRequestNoDemand(HttpWorkerRequest wr) System.Web.Hosting.ISAPIRuntime.ProcessRequest(IntPtr ecb, Int32 iWRType)
w3wp!library!5!03/21/2007-09:18:50:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details., un-named assertion fired for component processing; Info: Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details. w3wp!library!5!03/21/2007-09:19:22:: i INFO: Exception dumped to: C:Program FilesMicrosoft SQL ServerMSSQL.3Reporting ServicesLogFiles flags= ReferencedMemory, AllThreads, SendToWatson w3wp!webserver!5!03/21/2007-09:19:22:: e ERROR: Reporting Services error Microsoft.ReportingServices.Diagnostics.Utilities.RSException: An internal error occurred on the report server. See the error log for more details. ---> Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details. w3wp!library!b!03/21/2007-09:19:28:: i INFO: Call to RenderFirst( '/xxx Divested AR/Statements Report' ) w3wp!webserver!b!03/21/2007-09:19:29:: i INFO: Processed report. Report='/xxx Divested AR/Statements Report', Stream='' w3wp!library!6!03/21/2007-09:19:43:: i INFO: Call to RenderNext( '/xxx Divested AR/Statements Report' ) w3wp!cache!6!03/21/2007-09:19:43:: i INFO: Session live: /xxx Divested AR/Statements Report w3wp!webserver!7!03/21/2007-09:19:43:: i INFO: Processed report. Report='/xxx Divested AR/Statements Report', Stream='' w3wp!library!5!3/21/2007-09:20:25:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 1 snapshots, 10 chunks, 0 running jobs, 0 persisted streams
I'm using service broker queue with internal activation to run a stored procedure. The DB server is windows 2003 R2, 4 cpu, with SQL server 2005 SP2. When I'm runing the stored procedure directly from the sql management studio it takes about 75% of the cpu and running for about a minute, but when the stored procedure is activated by the queue internal activation (as a background process) it uses only 25% of the machine cpu (my guess it uses only 1 cpu insted of all 4 cpu) and running for much longer time (sometimes even more than one hour). How can I change this behavior? I want it to run as fast as possible.
The queue decleration is:
CREATE QUEUE [TaskQueue] WITH ACTIVATION ( STATUS = ON, PROCEDURE_NAME = ProcessTasksProc, MAX_QUEUE_READERS = 1, EXECUTE AS SELF);
Revenue 4 GB (4086 MB) Partitioned into 12 partitions (about 340 MB each) The count of records : almost 16.8 millions Each partition has approximately 1.4 million records
Algorithm chosen : TimeSeries Time Key : Period (6 digits integer with values range from 200501 to 200512, integer values) (Non-time) Key : Telephone number, variable-length string/text, max 15 char Input-and-predicted column1 : SLI007 Input-and-predicted column2 : SLI008
I have set the value for PERIODICITY_HINT to {12}. I created the project 3 times in 3 machines. All fail. The error message is the same :
Internal error : An unexpected exception occured. Internal error: An unexpected error occurred (file 'dmtimeseries.cpp', line 646, function 'DMTimeSeries::ProcessCaseTS3and4').
I searched for the file in C:Program FilesMicrosoft SQL Server and its subfolders. I didn't find it.
What causes the error?
I tested 3 machines to check whether the performance of the machine is the culprit.
Single processor Pentium M 2.0 GHz with 2 GB Memory Double processor Xeon 2.4 GHz with 3 GB Memory Double processor Xeon 3.4 GHz with 4 GB Memory
But the project in all those machines return the same error. Any idea?
I am looking for an example of a SP that shows the best practices for internal activation? In BOL this topic describes the typical patter for reading messages from a queue. What is the typical pattern for reading messages from a queue using an internally activated SP? Do we still need to loop (considering the message arrival actually fired the sp)?
I get the following error on the report that I am working on, as soon as I added a new item to my dataset. The error is: An internal error occured on the report server. See the error log for detail.
I added a new item to the dataset with the following expression:
=iif(Fields!Posting_Date.Value>=Fields!monthstartdate.Value and Fields!Posting_Date.Value <= Fields!monthenddate.Value,COUNTdistinct(Fields!Document_No_.Value),0)
I noticed some posts in regars to the count issue that has to do with system resources. I followed all the instructions, but no luck. Has anyone else experienced the same issue with the Count function and how were you able to resolve it ??
Hi all,I don’t know what happened to this function which was working OK for a few month and today it doesn’t work.In debug mode I kip getting “InvalidOperationaException was unhandled by user code”On this line:dtrResults = cmdSelect.ExecuteReader()Same behaviour on developping PCI cant find anithing that would create that problem. Function GetUserInfo(ByVal myUsr As String, ByVal strRequest As String) As String Dim strConString As String Dim conUsers As SqlConnection Dim cmdSelect As SqlCommand
strConString = ConfigurationSettings.AppSettings("conString2") conUsers = New SqlConnection(strConString) Dim dtrResults As SqlDataReader Dim intField As Integer Dim usr As String usr = "select " & strRequest & " user_ID from userlist where ul_user='" usr &= myUsr & "'" conUsers.Open() cmdSelect = New SqlCommand(usr, conUsers) dtrResults = cmdSelect.ExecuteReader() While dtrResults.Read() For intField = 0 To dtrResults.FieldCount - 1 GetUserInfo = dtrResults(intField).ToString() Next End While conUsers.Close() dtrResults.Close() Return GetUserInfo End Function Any Help will highly appriciated.Alex.
Hi all, i have copied out the database backup from development center to my local machine,it is having approx.8GB in size and when i m trying to restote this database backup in SQL Server 2000 it is showing me error. An internal consistency error occurred. Contact Technical Support for assistance. RESTORE DATABASE is terminating abnormally. Plz. anyone can help me..
Server: Msg 3270, Level 16, State 1, Line 1 An internal consistency error occurred. Contact Technical Support for assistance. Server: Msg 3013, Level 16, State 1, Line 1 RESTORE DATABASE is terminating abnormally.
The only google hit on Internal Error 2737 was a message archived here with no solution posted. I found that updating IE to 6.0 SP1 solved the Internal Error 2737, although I'm still not quite getting MSDE 2000 to run under Windows 98 First Edition. The Installer now installs without error, but the server manager doesn't turn the little SQL Server system tray icon green, the server doesn't seem to start up.
I am trying to setup a trace and save result to remote server by using EXEC xp_trace_setqueuedestination command. Same script was running fine on two server and failed on the other two (see attached error message). Search the Web and Microsoft don't find any clue. Can any one out there know anything about it.
Thank in advance.
Austinh
Server: Msg 19098, Level 10, State 1, Line 0 Internal Error QueueHandle ----------- 8
Hi,I am trying to execute rather complex query, and I got query processorerror. I read the Microsoft support page and it said I should install SP4,and I did, but the error is still there.I am running MSDE with SP4 installed. Everything else works like a charm.Zvonko
Hi, recently we increased our internal memory from 2 to 3.5 GB.Nevertheless, SQL Server does not seem to use this extra memory.Do we have to do something extra ???Arno de Jong,The Netherlands.
In the code below I get an Internal SQL Server error in QueryAnalyzer. Ultimately I want to get thos code working in a function.DECLARE @WeekNumber tinyintDECLARE @Comp decimal(18,2)DECLARE @PeriodFromDate datetimeDECLARE @PeriodToDate datetimeSET @WeekNumber = 27SET @PeriodFromDate = (SELECT MIN(StartDate) AS StartDate FROMCalendar WHERE WeekNumber = @WeekNumber)SET @PeriodToDate = (SELECT MAX(EndDate) AS StartDate FROM CalendarWHERE WeekNumber = @WeekNumber)SET @Comp = (SELECT SUM(ActualGrossComp)FROM dbo.fnc_ProgramLineUp_1_2()WHERE Delay > 0AND ClearanceCode <> 3AND TeleCastDate BETWEEN @PeriodFromDate AND PeriodToDate)But this code runs fine:DECLARE @WeekNumber tinyintDECLARE @Comp decimal(18,2)DECLARE @PeriodFromDate datetimeDECLARE @PeriodToDate datetimeSET @WeekNumber = 27SET @PeriodFromDate = (SELECT MIN(StartDate) AS StartDate FROMCalendar WHERE WeekNumber = @WeekNumber)SET @PeriodToDate = (SELECT MAX(EndDate) AS StartDate FROM CalendarWHERE WeekNumber = @WeekNumber)SELECT SUM(ActualGrossComp)FROM dbo.fnc_ProgramLineUp_1_2()WHERE Delay > 0AND ClearanceCode <> 3AND TeleCastDate BETWEEN @PeriodFromDate AND PeriodToDateThe only difference is that here I'm not setting @Comp to the returnvalue of the SELECT. This code also runs fine when I sum othercolumns. Any ideas?
I mange several large databases with multiple files and filegroups. During some maintenance I was trying to remove a filegroup and its files and noticed that I was unable to. It appears that some service broker objects were created on my user defined filegroup.
Looking at the system tables I see several system tables on my user defined filegroup
SELECT o.name +'.' +i.name FROM sysobjects o inner join sysindexes i on i.id = o.id where groupid = 2
I am a webdesigner who at the moment does not know SQL (although, I plan on remedying that) so I am developing a page with a DB designer - he is doing the DB work, I am doing the look/feel, but he asked me the following questions, of which I cannot seem to find an answer and the guys who tend our server are useless - so I am hoping someone here can help me. In general what he needs to know is:
"what is the external address (either in domain format or IP) and the equivalent internal address so that we can access the msSQL running on your server. The internal address is needed for the webpages to talk to it, while the external address is needed for development of the pages in visual studio and the database tools." Also, he later sent me an email asking that when I get this info (from someone) that it would be usefull to get a sample string/query to get access to the DB. I am running SQL 2000 and have enterprise manager. Where can I find this information? or how do I figure this out????
Thank you for all the help -- Please let me know if you need any more info.
