While selecting table data I m getting below error
Msg 5243, Level 22, State 8, Line 2
An inconsistency was detected during an internal operation. Please contact technical support.
Hi experts. I would like to ask for this error that I've encountered
(Error msg)
Msg 5242, Level 22, State 1, Line 1
An inconsistency was detected during an internal operation in database 'smartapp'(ID:9) on page (1:28827). Please contact technical support. Reference number 7.
then I tried executing this:
DBCC CHECKDB('Bizbox_training', 'smartapp')
DBCC CHECKDB('Bizbox_training', 'smartapp')
but this error still occurs, can you help me fixing this kind of problem. Thanks in advance.
I'm getting the following error:
An inconsistency was detected during an internal operation in database 'LocalLab2000'(ID:5) on page (1:19992). Please contact technical support. Reference number 5.
I ran DBCC CHECKDB ('locallab2000') and no error messages came up and still have the same problem.
I ran then dbcc checktable ('part') with DATA_PURITY and no error messager came up and the problem still whenever i select anuthing in that particular table.
Any ideas?
Thank you
I'm getting the following error:
Msg 5242, Level 22, State 1, Line 1
An inconsistency was detected during an internal operation in database 'LocalLab2000'(ID:5) on page (1:19992). Please contact technical support. Reference number 5.
I ran DBCC CHECKDB and there's no error messages neither alloc or consistency.
I ran dbcc checktable ('part') with DATA_PURITY and still no errors, but i still have the inconsistency error message whenever i access this particular table.
Any ideas?
-Ricardo Lozano
Hi All:
I have a trigger (just craeted) on of my tables.
The trigger makes use of the inserted and deleted psuedo tables.
When an event occurs where it fires the trigger, I am getting the following error:
"Msg 5243, Level 22, State 1, Procedure TR_PRICE_MAPPING_AUDIT, Line 39
An inconsistency was detected during an internal operation. Please contact technical support. Reference number 3."
I tried to drop the trigger and recreate it. Still the same issue.
I ahve other triggers that handle the same type of audit process i am doing, but do not cause an error.
Does anyone have any thoughts.
The Line 39, is the point where the OPEN call to the currsor.
Here is the code for the trigger:
Create TRIGGER [dbo].[TR_PRICE_MAPPING_AUDIT]
ON [dbo].[REST_MENU_PRICE_INCREASE_MAPPING]
AFTER UPDATE
AS
DECLARE
@V_NEW_PCT_INCREASE DECIMAL(18,2),
@V_OLD_PCT_INCREASE DECIMAL(18,2),
@V_REST_MAPPING_ID INT,
@V_OLD_IS_ACTIVE VARCHAR(3),
@V_NEW_IS_ACTIVE VARCHAR(3),
@V_OLD_IS_DELETE VARCHAR(3),
@V_NEW_IS_DELETE VARCHAR(3),
@V_OLD_BEGIN_DATETIME DATETIME,
@V_REST_ID INT
BEGIN
print N'test'
DECLARE PRICE_CUR CURSOR FOR
SELECT
D.REST_ID,
D.rest_price_mapping_id,
I.PCT_INCREASE,
D.PCT_INCREASE,
I.IS_ACTIVE,
D.IS_ACTIVE,
I.IS_DELETE,
D.IS_DELETE,
D.BEGIN_DATETIME
FROM INSERTED I, DELETED D
WHERE D.rest_price_mapping_id=I.rest_price_mapping_id
and d.pct_increase<>i.pct_increase
AND D.BEGIN_DATETIME<=GETDATE()
OPEN PRICE_CUR
FETCH NEXT FROM PRICE_CUR
INTO
@V_REST_ID,
@V_REST_MAPPING_ID,
@V_NEW_PCT_INCREASE ,
@V_OLD_PCT_INCREASE,
@V_NEW_IS_ACTIVE,
@V_OLD_IS_ACTIVE,
@V_NEW_IS_DELETE,
@V_OLD_IS_delete,
@V_OLD_BEGIN_DATETIME
WHILE @@FETCH_STATUS=0
BEGIN
BEGIN TRANSACTION
--THERE IS A CHNAGE IN ONE THE KEY ELEMENTS OF THE TABLE,
-- WE NEED TO SET CURRENT TO END_DATE AND INSERT NEW RECORD
INSERT INTO REST_MENU_PRICE_INCREASE_MAPPING_AUDIT
(REST_ID,REST_PRICE_MAPPING_ID,PCT_INCREASE,
BEGIN_DATETIME,END_DATETIME,
IS_ACTIVE,iS_DELETE)
VALUES(@V_REST_ID,@V_REST_MAPPING_ID,
@V_OLD_PCT_INCREASE,
@V_OLD_BEGIN_DATETIME,GETDATE(),
@V_OLD_IS_ACTIVE,@V_OLD_IS_DELETE)
UPDATE REST_MENU_PRICE_INCREASE_MAPPING
SET BEGIN_DATETIME=GETDATE()
WHERE REST_PRICE_MAPPING_ID=@V_REST_MAPPING_ID
COMMIT TRANSACTION
FETCH NEXT FROM PRICE_CUR
INTO
@V_REST_ID,
@V_REST_MAPPING_ID,
@V_NEW_PCT_INCREASE ,
@V_OLD_PCT_INCREASE,
@V_NEW_IS_ACTIVE,
@V_OLD_IS_ACTIVE,
@V_NEW_IS_DELETE,
@V_OLD_IS_delete,
@V_OLD_BEGIN_DATETIME
END
CLOSE PRICE_CUR
DEALLOCATE PRICE_CUR
END
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
Frequently, when I'm connecting to my server through SSMS i get "Is Busy: Microsoft SQL Server is waiting to complete an internal operation...."
And it tells me that if I get that message a lot, I should let Microsoft know.
So -- Microsoft, I'm letting you know.
Can anyone tell me why this is happening? I've searched MSDN and the knowledge base...I can only find one reference, and that is to a database diagram issue.
It takes a while to connect when this happens. So far, I haven't found a common denominator. It happens if I'm logged into my server and I try to connect to another instance, and it happens when I'm using my desktop...
I have an UPDATE statement that joins two table by SendId. One table, I'll call it T1, has a clustered index on SendId ASC. The other table I will call T2 also has a clustered index on SendID ASC. All the columns from T2 are used to update T1. The execution plan shows a Clustered index scan on T2 and a Clustered Index Seek on T1 going into a Nested Loops inner join. Immediately following is a Distinct Sort that is done on SendId ASC. Why the Distinct SORT if the tables are already ordered by SendID?
View 8 Replies View RelatedDid anyone familiar with these errors:
SQL Server detected a logical consistency-based I/O error: incorrect checksum (expected: 0x1a00d2fd; actual: 0x1a02d2fd). It occurred during a read of page (1:103329) in database ID 11 at offset 0x00000032742000 in file 'C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLDATAServer02.mdf'. Additional messages in the SQL Server error log or system event log may provide more detail. This is a severe error condition that threatens database integrity and must be corrected immediately. Complete a full database c (Source: MSSQLServer, Error number: 824)
Get help: http://help/824
Thank you.
TJ_1
I am currently running SQL 2014 in my production environment. Both machines are configured for Windows Failover Cluster Services so that we could take advantage of AlwaysOn Availability Groups.
Currently we are experiencing a issue where our web application is throwing an error, "Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding." I am pretty sure that the error is being thrown from the application, but I can't prove it. Because the error states it is SQL, the consensus seems to be that SQL is having the issue. I need to know how to troubleshoot it to ensure that SQL is not the problem.
Hi,
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:
w3wp!processing!1!05/11/2007-10:40:06:: 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)
I don't see any hint in stack trace, Maybe one of yours.
As it seems, after an iisreset the first rendering always works perfect. HD space is enough.
Any ideas?
We have reports deployed in the Report Server. While connecting from client, we are getting the error
"An internal error occurred on the report server. See the error log for more details. rsInternal Error)"
Then we went to Report Server, Reporting Service and SQL Server service are all are running fine.
Important thing is some time the reports are working fine, sometimes i am receiving this error. Please help.
We predict whether the services are automatically restarted or transaction logs exceeding the limit or any other parameters to set to avaoid this error?
Please help.
I have the error above, but no error log. I can preview the sub report - but this main report fails after working this morning. This is for internal company reports and I rebuilt this one after converting from access.
I have looked where the error logs should be, but there are no error logs.
I rebuilt the query as I needed to change this, but this did not help.
Is there someone who could point me in the correct direction.
Thanks!
Terry
I got Form Authentication to work, but I am getting this error sometimes. To reproduce this error consistantly is to run iisreset.exe to have a fresh start. Go to my report server login and open any report.
The page will display: The remote server returned an error: (500) Internal Server Error.
If i click "F5" to refresh the page the report will show up or if you go to another report it will work also. It is just the first time after iisreset.exe. It is very strange.
Here is my log file:
aspnet_wp!library!6!03/11/2008-15:20:36:: i INFO: Exception dumped to: c:Program FilesMicrosoft SQL ServerMSSQL.4Reporting ServicesLogFiles flags= ReferencedMemory, AllThreads, SendToWatson
aspnet_wp!library!6!03/11/2008-15:20:47:: Call to GetPermissionsAction(/).
aspnet_wp!library!1!03/11/2008-15:20:47:: Call to GetPropertiesAction(/, PathBased).
aspnet_wp!library!6!03/11/2008-15:20:48:: Call to GetSystemPermissionsAction().
aspnet_wp!library!1!03/11/2008-15:20:48:: Call to ListChildrenAction(/, False).
aspnet_wp!library!6!03/11/2008-15:20:49:: Call to GetSystemPropertiesAction().
aspnet_wp!library!1!03/11/2008-15:20:49:: Call to GetSystemPropertiesAction().
aspnet_wp!library!a!03/11/2008-15:20:53:: Call to GetPermissionsAction(/Sentrack).
aspnet_wp!library!1!03/11/2008-15:20:53:: Call to GetPropertiesAction(/Sentrack, PathBased).
aspnet_wp!library!a!03/11/2008-15:20:54:: Call to GetSystemPermissionsAction().
aspnet_wp!library!1!03/11/2008-15:20:54:: Call to ListChildrenAction(/Sentrack, False).
aspnet_wp!library!a!03/11/2008-15:20:56:: Call to GetSystemPropertiesAction().
aspnet_wp!library!1!03/11/2008-15:20:56:: Call to GetSystemPropertiesAction().
aspnet_wp!library!6!03/11/2008-15:20:58:: Call to GetPermissionsAction(/Sentrack/Shared Reports).
aspnet_wp!library!1!03/11/2008-15:20:59:: Call to GetPropertiesAction(/Sentrack/Shared Reports, PathBased).
aspnet_wp!library!6!03/11/2008-15:20:59:: Call to GetSystemPermissionsAction().
aspnet_wp!library!1!03/11/2008-15:20:59:: Call to ListChildrenAction(/Sentrack/Shared Reports, False).
aspnet_wp!library!6!03/11/2008-15:21:00:: Call to GetSystemPropertiesAction().
aspnet_wp!library!1!03/11/2008-15:21:00:: Call to GetSystemPropertiesAction().
aspnet_wp!library!a!03/11/2008-15:21:04:: Call to GetPermissionsAction(/Sentrack/Shared Reports/Report).
aspnet_wp!library!1!03/11/2008-15:21:04:: Call to GetSystemPropertiesAction().
aspnet_wp!library!a!03/11/2008-15:21:05:: Call to GetPropertiesAction(/Sentrack/Shared Reports/Report, PathBased).
aspnet_wp!library!1!03/11/2008-15:21:05:: Call to GetSystemPermissionsAction().
aspnet_wp!library!a!03/11/2008-15:21:06:: Call to GetPropertiesAction(/Sentrack/Shared Reports/Report, PathBased).
aspnet_wp!library!1!03/11/2008-15:21:06:: Call to ListEventsAction().
aspnet_wp!library!1!03/11/2008-15:21:07:: Unhandled exception was caught: System.Web.HttpException: File does not exist.
at System.Web.StaticFileHandler.ProcessRequestInternal(HttpContext context)
at System.Web.DefaultHttpHandler.BeginProcessRequest(HttpContext context, AsyncCallback callback, Object state)
at System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)
aspnet_wp!library!1!03/11/2008-15:21:07:: 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.Web.HttpException: File does not exist.
at System.Web.StaticFileHandler.ProcessRequestInternal(HttpContext context)
at System.Web.DefaultHttpHandler.BeginProcessRequest(HttpContext context, AsyncCallback callback, Object state)
at System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)
--- End of inner exception stack trace ---
Any ideas?
When my production server processing some queries suddenly the SQL Server service crashed and following error was in the error log:
SQL Server Internal Error. Text manager cannot continue with current statement.
The server is running SQL Server 2000 with SP4.
I am really concerned because this is a production sever and there are over 300 users access concurrently.
Please help me to find a solution.
Thanks,
Roshan.
I have created an RDL file programatically. When I execute the code I get the error as mentioned below:
Error: Sub report cannot be shown.
An internal error occurred on the report server. See the error log for more details. (rsInternalError)
When I copy and paste the code of RDL file into new RDL file and try to preview the output I get correct result.
Note: The new RDL file does not give any error if the output is seen using preview tab but it gives the error only when executed from report viewer or from internet explorer.
Any Suggestion/feedback is highly appreciated.
Thank You.
The code of the sample RDL is shown below:
<?xml version="1.0" encoding="utf-8"?>
<Report xmlns="http://schemas.microsoft.com/sqlserver/reporting/2005/01/reportdefinition" xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">
<DataSources>
<DataSource Name="DataSource1">
<DataSourceReference>DataSource1</DataSourceReference>
<rd:DataSourceID>fe4806ee-0358-4a87-b764-ac5de049545e</rd:DataSourceID>
</DataSource>
</DataSources>
<BottomMargin>0.25in</BottomMargin>
<RightMargin>0.25in</RightMargin>
<PageWidth>11in</PageWidth>
<ReportParameters>
<ReportParameter Name="machine_id">
<DataType>String</DataType>
<Prompt>machine_id</Prompt>
</ReportParameter>
<ReportParameter Name="from_date">
<DataType>String</DataType>
<AllowBlank>true</AllowBlank>
<Prompt>From Date</Prompt>
</ReportParameter>
<ReportParameter Name="to_date">
<DataType>String</DataType>
<AllowBlank>true</AllowBlank>
<Prompt>To Date</Prompt>
</ReportParameter>
</ReportParameters>
<rd:DrawGrid>true</rd:DrawGrid>
<InteractiveWidth>8.5in</InteractiveWidth>
<rd:SnapToGrid>true</rd:SnapToGrid>
<Body>
<ReportItems>
<Table Name="table1">
<DataSetName>Main_Report</DataSetName>
<TableGroups>
<TableGroup>
<Header>
<TableRows>
<TableRow>
<TableCells>
<TableCell>
<ReportItems>
<Textbox Name="textbox2">
<rd:DefaultName>textbox2</rd:DefaultName>
<ZIndex>1</ZIndex>
<Style>
<TextAlign>Left</TextAlign>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Value>=Fields!syscode.Value</Value>
</Textbox>
</ReportItems>
</TableCell>
</TableCells>
<Height>0.25in</Height>
</TableRow>
</TableRows>
<RepeatOnNewPage>true</RepeatOnNewPage>
</Header>
<Grouping Name="table1_Group1">
<PageBreakAtEnd>true</PageBreakAtEnd>
<GroupExpressions>
<GroupExpression>=Fields!syscode.Value</GroupExpression>
</GroupExpressions>
</Grouping>
</TableGroup>
</TableGroups>
<Details>
<TableRows>
<TableRow>
<TableCells>
<TableCell>
<ReportItems>
<Subreport Name="subreport1">
<Parameters>
<Parameter Name="machine_id">
<Value>=Fields!machine_ip.Value</Value>
</Parameter>
<Parameter Name="syscode">
<Value>=Fields!syscode.Value</Value>
</Parameter>
<Parameter Name="from_date">
<Value>=Parameters!from_date.Value</Value>
</Parameter>
<Parameter Name="to_date">
<Value>=Parameters!to_date.Value</Value>
</Parameter>
</Parameters>
<ReportName>Holding_Summary_Multi_Period</ReportName>
</Subreport>
</ReportItems>
</TableCell>
</TableCells>
<Height>0.25in</Height>
</TableRow>
</TableRows>
</Details>
<TableColumns>
<TableColumn>
<Width>10.5in</Width>
</TableColumn>
</TableColumns>
<Height>0.5in</Height>
</Table>
</ReportItems>
<Height>0.75in</Height>
</Body>
<rd:ReportID>d0a1293a-e98c-4f75-9597-03426d2e7218</rd:ReportID>
<LeftMargin>0.25in</LeftMargin>
<DataSets>
<DataSet Name="Main_Report">
<Query>
<rd:UseGenericDesigner>true</rd:UseGenericDesigner>
<CommandText>select account_syscode as syscode , 'display Name' as display_name , * from mars_customer_list
where machine_ip = @machine_id</CommandText>
<QueryParameters>
<QueryParameter Name="@machine_id">
<Value>=Parameters!machine_id.Value</Value>
</QueryParameter>
</QueryParameters>
<DataSourceName>DataSource1</DataSourceName>
</Query>
<Fields>
<Field Name="syscode">
<rd:TypeName>System.Int64</rd:TypeName>
<DataField>syscode</DataField>
</Field>
<Field Name="display_name">
<rd:TypeName>System.String</rd:TypeName>
<DataField>display_name</DataField>
</Field>
<Field Name="customer_syscode">
<rd:TypeName>System.Int64</rd:TypeName>
<DataField>customer_syscode</DataField>
</Field>
<Field Name="account_syscode">
<rd:TypeName>System.Int64</rd:TypeName>
<DataField>account_syscode</DataField>
</Field>
<Field Name="machine_ip">
<rd:TypeName>System.String</rd:TypeName>
<DataField>machine_ip</DataField>
</Field>
</Fields>
</DataSet>
</DataSets>
<Code>Shared offset As Integer
Public Function GetPN(reset As Boolean, pagenumber As Integer) As Integer
If reset
offset = pagenumber - 1
End If
Return pagenumber - offset
End Function
</Code>
<Width>10.5in</Width>
<InteractiveHeight>11in</InteractiveHeight>
<Language>en-US</Language>
<PageFooter>
<ReportItems>
<Image Name="image1">
<Sizing>Fit</Sizing>
<Left>8.875in</Left>
<MIMEType />
<Width>1.5in</Width>
<Source>External</Source>
<Style />
<Value>bottom_right_logo.gif</Value>
</Image>
</ReportItems>
<Height>0.5in</Height>
<PrintOnLastPage>true</PrintOnLastPage>
<PrintOnFirstPage>true</PrintOnFirstPage>
</PageFooter>
<TopMargin>0.5in</TopMargin>
<PageHeight>8.5in</PageHeight>
</Report>
I have a SProc that runs across many clients without any problems. Every now and then, though, I get the following error:
Internal Query Processor Error: The query processor encountered an unexpected error during execution. [SQLSTATE 42000] (Error 8630).
All I am doing is populating Temp tables with some data and then joining them together to create a Global Temp table that is being BCP'd to a network share.
Has anyone come across this error in SQL Server 2005? I cannot find anything on Google or Microcsoft.
Thanks,
Robert
Hello everybody,
I am trying to use the reporting services on Windows 2003 with SQLServer 2005. Everything works fine in the report manager and I can access and render the reports without any problem. But when I try to access the reports directly with the URL from the ReportServer, I get the following error :
Reporting Services Error
An internal error occurred on the report server. See the error log for more details. (rsInternalError) Get Online Help
The type Microsoft.ReportingServices.UI.WebControlConnection, ReportingServicesWebUserInterface, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91 does not implement IReportServerConnection or could not be found
SQL Server Reporting Services
So I went to see the error log, and here is what it says :
<Header>
<Product>Microsoft SQL Server Reporting Services Version 9.00.1399.00</Product>
<Locale>en-US</Locale>
<TimeZone>GMT Standard Time</TimeZone>
<Path>C:Program FilesMicrosoft SQL ServerMSSQL.3Reporting ServicesLogFilesReportServer__11_10_2006_13_43_22.log</Path>
<SystemName>VODAFONE</SystemName>
<OSName>Microsoft Windows NT 5.2.3790 Service Pack 1</OSName>
<OSVersion>5.2.3790.65536</OSVersion>
</Header>
w3wp!webserver!5!11/10/2006-13:43:23:: i INFO: Reporting Web Server started
w3wp!library!5!11/10/2006-13:43:23:: i INFO: Initializing ConnectionType to '0' as specified in Configuration file.
w3wp!library!5!11/10/2006-13:43:23:: i INFO: Initializing IsSchedulingService to 'True' as specified in Configuration file.
w3wp!library!5!11/10/2006-13:43:23:: i INFO: Initializing IsNotificationService to 'True' as specified in Configuration file.
w3wp!library!5!11/10/2006-13:43:23:: i INFO: Initializing IsEventService to 'True' as specified in Configuration file.
w3wp!library!5!11/10/2006-13:43:23:: i INFO: Initializing PollingInterval to '10' second(s) as specified in Configuration file.
w3wp!library!5!11/10/2006-13:43:23:: i INFO: Initializing WindowsServiceUseFileShareStorage to 'False' as specified in Configuration file.
w3wp!library!5!11/10/2006-13:43:23:: i INFO: Initializing MemoryLimit to '60' percent as specified in Configuration file.
w3wp!library!5!11/10/2006-13:43:23:: i INFO: Initializing RecycleTime to '720' minute(s) as specified in Configuration file.
w3wp!library!5!11/10/2006-13:43:23:: i INFO: Initializing MaximumMemoryLimit to '80' percent as specified in Configuration file.
w3wp!library!5!11/10/2006-13:43:23:: i INFO: Initializing MaxAppDomainUnloadTime to '30' minute(s) as specified in Configuration file.
w3wp!library!5!11/10/2006-13:43:23:: i INFO: Initializing MaxQueueThreads to '0' thread(s) as specified in Configuration file.
w3wp!library!5!11/10/2006-13:43:23:: i INFO: Initializing IsWebServiceEnabled to 'True' as specified in Configuration file.
w3wp!library!5!11/10/2006-13:43:23:: i INFO: Initializing MaxActiveReqForOneUser to '20' requests(s) as specified in Configuration file.
w3wp!library!5!11/10/2006-13:43:23:: i INFO: Initializing MaxScheduleWait to '5' second(s) as specified in Configuration file.
w3wp!library!5!11/10/2006-13:43:23:: i INFO: Initializing DatabaseQueryTimeout to '120' second(s) as specified in Configuration file.
w3wp!library!5!11/10/2006-13:43:23:: i INFO: Initializing ProcessRecycleOptions to '0' as specified in Configuration file.
w3wp!library!5!11/10/2006-13:43:23:: i INFO: Initializing RunningRequestsScavengerCycle to '60' second(s) as specified in Configuration file.
w3wp!library!5!11/10/2006-13:43:23:: i INFO: Initializing RunningRequestsDbCycle to '60' second(s) as specified in Configuration file.
w3wp!library!5!11/10/2006-13:43:23:: i INFO: Initializing RunningRequestsAge to '30' second(s) as specified in Configuration file.
w3wp!library!5!11/10/2006-13:43:23:: i INFO: Initializing CleanupCycleMinutes to '10' minute(s) as specified in Configuration file.
w3wp!library!5!11/10/2006-13:43:23:: i INFO: Initializing DailyCleanupMinuteOfDay to default value of '120' minutes since midnight because it was not specified in Configuration file.
w3wp!library!5!11/10/2006-13:43:23:: i INFO: Initializing WatsonFlags to '1064' as specified in Configuration file.
w3wp!library!5!11/10/2006-13:43:23:: i INFO: Initializing WatsonDumpOnExceptions to 'Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException,Microsoft.ReportingServices.Modeling.InternalModelingException' as specified in Configuration file.
w3wp!library!5!11/10/2006-13:43:23:: i INFO: Initializing WatsonDumpExcludeIfContainsExceptions to 'System.Data.SqlClient.SqlException,System.Threading.ThreadAbortException' as specified in Configuration file.
w3wp!library!5!11/10/2006-13:43:23:: i INFO: Initializing SecureConnectionLevel to '0' as specified in Configuration file.
w3wp!library!5!11/10/2006-13:43:23:: i INFO: Initializing DisplayErrorLink to 'True' as specified in Configuration file.
w3wp!library!5!11/10/2006-13:43:23:: i INFO: Initializing WebServiceUseFileShareStorage to 'False' as specified in Configuration file.
w3wp!resourceutilities!5!11/10/2006-13:43:23:: i INFO: Reporting Services starting SKU: Enterprise
w3wp!resourceutilities!5!11/10/2006-13:43:23:: i INFO: Evaluation copy: 0 days left
w3wp!runningjobs!5!11/10/2006-13:43:23:: i INFO: Database Cleanup (Web Service) timer enabled: Next Event: 600 seconds. Cycle: 600 seconds
w3wp!runningjobs!5!11/10/2006-13:43:23:: i INFO: Running Requests Scavenger timer enabled: Next Event: 60 seconds. Cycle: 60 seconds
w3wp!runningjobs!5!11/10/2006-13:43:23:: i INFO: Running Requests DB timer enabled: Next Event: 60 seconds. Cycle: 60 seconds
w3wp!runningjobs!5!11/10/2006-13:43:23:: i INFO: Memory stats update timer enabled: Next Event: 60 seconds. Cycle: 60 seconds
w3wp!library!5!10/11/2006-13:43:23:: Unhandled exception was caught: Microsoft.Reporting.WebForms.InvalidConfigFileTypeException: The type Microsoft.ReportingServices.UI.WebControlConnection, ReportingServicesWebUserInterface, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91 does not implement IReportServerConnection or could not be found
at Microsoft.Reporting.WebForms.ConfigFilePropertyInterface`1.EnsurePropertyLoaded()
at Microsoft.Reporting.WebForms.ConfigFilePropertyInterface`1.GetInstance()
at Microsoft.Reporting.WebForms.ReportViewer.CreateServerReport()
at Microsoft.Reporting.WebForms.ReportViewer..ctor()
at Microsoft.ReportingServices.WebServer.ReportViewerHost..ctor()
at ASP.pages_reportviewer_aspx.__BuildControlReportViewerForm()
at ASP.pages_reportviewer_aspx.__BuildControlTree(pages_reportviewer_aspx __ctrl)
at ASP.pages_reportviewer_aspx.FrameworkInitialize()
at System.Web.UI.Page.ProcessRequest(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
at System.Web.UI.Page.ProcessRequest()
at System.Web.UI.Page.ProcessRequestWithNoAssert(HttpContext context)
at System.Web.UI.Page.ProcessRequest(HttpContext context)
at ASP.pages_reportviewer_aspx.ProcessRequest(HttpContext context)
at System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)
w3wp!library!5!10/11/2006-13:43: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. ---> Microsoft.Reporting.WebForms.InvalidConfigFileTypeException: The type Microsoft.ReportingServices.UI.WebControlConnection, ReportingServicesWebUserInterface, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91 does not implement IReportServerConnection or could not be found
at Microsoft.Reporting.WebForms.ConfigFilePropertyInterface`1.EnsurePropertyLoaded()
at Microsoft.Reporting.WebForms.ConfigFilePropertyInterface`1.GetInstance()
at Microsoft.Reporting.WebForms.ReportViewer.CreateServerReport()
at Microsoft.Reporting.WebForms.ReportViewer..ctor()
at Microsoft.ReportingServices.WebServer.ReportViewerHost..ctor()
at ASP.pages_reportviewer_aspx.__BuildControlReportViewerForm()
at ASP.pages_reportviewer_aspx.__BuildControlTree(pages_reportviewer_aspx __ctrl)
at ASP.pages_reportviewer_aspx.FrameworkInitialize()
at System.Web.UI.Page.ProcessRequest(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
at System.Web.UI.Page.ProcessRequest()
at System.Web.UI.Page.ProcessRequestWithNoAssert(HttpContext context)
at System.Web.UI.Page.ProcessRequest(HttpContext context)
at ASP.pages_reportviewer_aspx.ProcessRequest(HttpContext context)
at System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)
--- End of inner exception stack trace ---
w3wp!library!5!10/11/2006-13:43:25:: i INFO: Exception dumped to: C:Program FilesMicrosoft SQL ServerMSSQL.3Reporting ServicesLogFiles flags= ReferencedMemory, AllThreads, SendToWatson
w3wp!library!5!10/11/2006-13:43:26:: i INFO: Catalog SQL Server Edition = Enterprise
w3wp!webserver!5!11/10/2006-13:43:34:: i INFO: Reporting Web Server stopped
Does anyone have any idea about what happends ? Any suggestions maybe about anything I should try ?
Thanks very much in advance.
[edit] I just installed a few minutes ago the service pack 1 for SQL Server 2005 and Reporting services, but obviously it doesn't change anything to my problem. [/edit]
An internal error occurred on the report server. See the error log for more details. (rsInternalError) - This is the error I get when I try to edit a subcription then click finish.Where do I start in solving this?, heres the log -<Header>
<Product>Microsoft SQL Server Reporting Services Version 9.00.3042.00</Product>
<Locale>en-US</Locale>
<TimeZone>GMT Daylight Time</TimeZone>
<Path>C:Program FilesMicrosoft SQL ServerMSSQL.3Reporting ServicesLogFilesReportServerWebApp__06_14_2007_12_02_20.log</Path>
<SystemName>MCSCITRIX</SystemName>
<OSName>Microsoft Windows NT 5.2.3790 Service Pack 1</OSName>
<OSVersion>5.2.3790.65536</OSVersion>
</Header>
w3wp!library!1!14/06/2007-12:02:21:: i INFO: Initializing ReportBuilderTrustLevel to '0' as specified in Configuration file.
w3wp!library!1!14/06/2007-12:02:21:: i INFO: Initializing MaxActiveReqForOneUser to '20' requests(s) as specified in Configuration file.
w3wp!library!1!14/06/2007-12:02:21:: i INFO: Initializing MaxScheduleWait to default value of '1' second(s) because it was not specified in Configuration file.
w3wp!library!1!14/06/2007-12:02:21:: i INFO: Initializing DatabaseQueryTimeout to default value of '30' second(s) because it was not specified in Configuration file.
w3wp!library!1!14/06/2007-12:02:21:: i INFO: Initializing ProcessRecycleOptions to default value of '0' because it was not specified in Configuration file.
w3wp!library!1!14/06/2007-12:02:21:: i INFO: Initializing RunningRequestsScavengerCycle to default value of '30' second(s) because it was not specified in Configuration file.
w3wp!library!1!14/06/2007-12:02:21:: i INFO: Initializing RunningRequestsDbCycle to default value of '30' second(s) because it was not specified in Configuration file.
w3wp!library!1!14/06/2007-12:02:21:: i INFO: Initializing RunningRequestsAge to default value of '30' second(s) because it was not specified in Configuration file.
w3wp!library!1!14/06/2007-12:02:21:: i INFO: Initializing CleanupCycleMinutes to default value of '10' minute(s) because it was not specified in Configuration file.
w3wp!library!1!14/06/2007-12:02:21:: i INFO: Initializing DailyCleanupMinuteOfDay to default value of '120' minutes since midnight because it was not specified in Configuration file.
w3wp!library!1!14/06/2007-12:02:21:: i INFO: Initializing WatsonFlags to default value of '1064' because it was not specified in Configuration file.
w3wp!library!1!14/06/2007-12:02:21:: i INFO: Initializing WatsonDumpOnExceptions to default value of 'Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException,Microsoft.ReportingServices.Modeling.InternalModelingException' because it was not specified in Configuration file.
w3wp!library!1!14/06/2007-12:02:21:: i INFO: Initializing WatsonDumpExcludeIfContainsExceptions to default value of 'System.Data.SqlClient.SqlException,System.Threading.ThreadAbortException' because it was not specified in Configuration file.
w3wp!library!1!14/06/2007-12:02:21:: i INFO: Initializing SecureConnectionLevel to default value of '1' because it was not specified in Configuration file.
w3wp!library!1!14/06/2007-12:02:21:: i INFO: Initializing DisplayErrorLink to 'True' as specified in Configuration file.
w3wp!library!1!14/06/2007-12:02:21:: i INFO: Initializing WebServiceUseFileShareStorage to default value of 'False' because it was not specified in Configuration file.
w3wp!ui!5!14/06/2007-12:06:09:: e ERROR: System.Web.Services.Protocols.SoapException: 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. ---> System.Data.SqlClient.SqlException: Only members of sysadmin role are allowed to update or delete jobs owned by a different login.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at Microsoft.ReportingServices.Library.InstrumentedSqlCommand.ExecuteNonQuery()
at Microsoft.ReportingServices.Library.SqlAgentScheduler.DeleteTask(Guid id)
at Microsoft.ReportingServices.Library.SqlAgentScheduler.UpdateTask(Task task)
at Microsoft.ReportingServices.Library.SchedulingDBInterface.UpdateTaskProperties(Task task, Boolean updateSqlAgentSchedule)
at Microsoft.ReportingServices.Library.TimedSubscriptionHandler.ValidateSubscriptionData(Subscription subscription, String subscriptionData, UserContext userContext)
at Microsoft.ReportingServices.Library.SubscriptionManager.ValidateSubscriptionData(Subscription subscription, String eventType, String subscriptionData)
at Microsoft.ReportingServices.Library.SubscriptionManager.SetSubscriptionProperties(Guid id, String eventType, String matchData, ExtensionSettings extensionSettings, String description, ParameterValueOrFieldReference[] parameters, DataRetrievalPlan dataSettings)
at Microsoft.ReportingServices.Library.SetSubscriptionPropertiesAction.PerformActionNow()
at Microsoft.ReportingServices.Library.RSSoapAction`1.Execute()
--- End of inner exception stack trace ---
at Microsoft.ReportingServices.Library.RSSoapAction`1.Execute()
at Microsoft.ReportingServices.WebServer.ReportingService2005Impl.SetSubscriptionProperties(String SubscriptionID, ExtensionSettings ExtensionSettings, Boolean isDataDriven, DataRetrievalPlan DataRetrievalPlan, String Description, String EventType, String MatchData, ParameterValueOrFieldReference[] Parameters)
--- End of inner exception stack trace ---
at Microsoft.ReportingServices.WebServer.ReportingService2005Impl.SetSubscriptionProperties(String SubscriptionID, ExtensionSettings ExtensionSettings, Boolean isDataDriven, DataRetrievalPlan DataRetrievalPlan, String Description, String EventType, String MatchData, ParameterValueOrFieldReference[] Parameters)
at Microsoft.ReportingServices.WebServer.ReportingService2005.SetDataDrivenSubscriptionProperties(String DataDrivenSubscriptionID, ExtensionSettings ExtensionSettings, DataRetrievalPlan DataRetrievalPlan, String Description, String EventType, String MatchData, ParameterValueOrFieldReference[] Parameters)
w3wp!ui!5!14/06/2007-12:06:09:: e ERROR: HTTP status code --> 200
-------Details--------
System.Web.Services.Protocols.SoapException: System.Web.Services.Protocols.SoapException: 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. ---> System.Data.SqlClient.SqlException: Only members of sysadmin role are allowed to update or delete jobs owned by a different login.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at Microsoft.ReportingServices.Library.InstrumentedSqlCommand.ExecuteNonQuery()
at Microsoft.ReportingServices.Library.SqlAgentScheduler.DeleteTask(Guid id)
at Microsoft.ReportingServices.Library.SqlAgentScheduler.UpdateTask(Task task)
at Microsoft.ReportingServices.Library.SchedulingDBInterface.UpdateTaskProperties(Task task, Boolean updateSqlAgentSchedule)
at Microsoft.ReportingServices.Library.TimedSubscriptionHandler.ValidateSubscriptionData(Subscription subscription, String subscriptionData, UserContext userContext)
at Microsoft.ReportingServices.Library.SubscriptionManager.ValidateSubscriptionData(Subscription subscription, String eventType, String subscriptionData)
at Microsoft.ReportingServices.Library.SubscriptionManager.SetSubscriptionProperties(Guid id, String eventType, String matchData, ExtensionSettings extensionSettings, String description, ParameterValueOrFieldReference[] parameters, DataRetrievalPlan dataSettings)
at Microsoft.ReportingServices.Library.SetSubscriptionPropertiesAction.PerformActionNow()
at Microsoft.ReportingServices.Library.RSSoapAction`1.Execute()
--- End of inner exception stack trace ---
at Microsoft.ReportingServices.Library.RSSoapAction`1.Execute()
at Microsoft.ReportingServices.WebServer.ReportingService2005Impl.SetSubscriptionProperties(String SubscriptionID, ExtensionSettings ExtensionSettings, Boolean isDataDriven, DataRetrievalPlan DataRetrievalPlan, String Description, String EventType, String MatchData, ParameterValueOrFieldReference[] Parameters)
--- End of inner exception stack trace ---
at Microsoft.ReportingServices.WebServer.ReportingService2005Impl.SetSubscriptionProperties(String SubscriptionID, ExtensionSettings ExtensionSettings, Boolean isDataDriven, DataRetrievalPlan DataRetrievalPlan, String Description, String EventType, String MatchData, ParameterValueOrFieldReference[] Parameters)
at Microsoft.ReportingServices.WebServer.ReportingService2005.SetDataDrivenSubscriptionProperties(String DataDrivenSubscriptionID, ExtensionSettings ExtensionSettings, DataRetrievalPlan DataRetrievalPlan, String Description, String EventType, String MatchData, ParameterValueOrFieldReference[] Parameters)
at System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall)
at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters)
at Microsoft.SqlServer.ReportingServices2005.ReportingService2005.SetDataDrivenSubscriptionProperties(String DataDrivenSubscriptionID, ExtensionSettings ExtensionSettings, DataRetrievalPlan DataRetrievalPlan, String Description, String EventType, String MatchData, ParameterValueOrFieldReference[] Parameters)
at Microsoft.SqlServer.ReportingServices2005.RSConnection.SetDataDrivenSubscriptionProperties(String DataDrivenSubscriptionID, ExtensionSettings ExtensionSettings, DataRetrievalPlan DataRetrievalPlan, String Description, String EventType, String MatchData, ParameterValueOrFieldReference[] Parameters)
at Microsoft.ReportingServices.UI.DataDrivenSubscription.Save()
at Microsoft.ReportingServices.UI.DataDrivenPropertiesControl.Buttons_FinishClick(Object sender, EventArgs args)
at Microsoft.ReportingServices.UI.WizardButtons.OnFinishedClicked(EventArgs args)
at Microsoft.ReportingServices.UI.WizardButtons.FinishButton_Click(Object sender, EventArgs args)
at System.Web.UI.WebControls.Button.OnClick(EventArgs e)
at System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument)
at System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument)
at System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument)
at System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData)
at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
w3wp!ui!5!14/06/2007-12:06:09:: e ERROR: Exception in ShowErrorPage: System.Threading.ThreadAbortException: Thread was being aborted.
at System.Threading.Thread.AbortInternal()
at System.Threading.Thread.Abort(Object stateInfo)
at System.Web.HttpResponse.End()
at System.Web.HttpServerUtility.Transfer(String path, Boolean preserveForm)
at Microsoft.ReportingServices.UI.ReportingPage.ShowErrorPage(String errMsg) at at System.Threading.Thread.AbortInternal()
at System.Threading.Thread.Abort(Object stateInfo)
at System.Web.HttpResponse.End()
at System.Web.HttpServerUtility.Transfer(String path, Boolean preserveForm)
at Microsoft.ReportingServices.UI.ReportingPage.ShowErrorPage(String errMsg)
w3wp!ui!b!6/14/2007-12:08:23:: e ERROR: System.Web.Services.Protocols.SoapException: 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. ---> System.Data.SqlClient.SqlException: Only members of sysadmin role are allowed to update or delete jobs owned by a different login.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at Microsoft.ReportingServices.Library.InstrumentedSqlCommand.ExecuteNonQuery()
at Microsoft.ReportingServices.Library.SqlAgentScheduler.DeleteTask(Guid id)
at Microsoft.ReportingServices.Library.SqlAgentScheduler.UpdateTask(Task task)
at Microsoft.ReportingServices.Library.SchedulingDBInterface.UpdateTaskProperties(Task task, Boolean updateSqlAgentSchedule)
at Microsoft.ReportingServices.Library.TimedSubscriptionHandler.ValidateSubscriptionData(Subscription subscription, String subscriptionData, UserContext userContext)
at Microsoft.ReportingServices.Library.SubscriptionManager.ValidateSubscriptionData(Subscription subscription, String eventType, String subscriptionData)
at Microsoft.ReportingServices.Library.SubscriptionManager.SetSubscriptionProperties(Guid id, String eventType, String matchData, ExtensionSettings extensionSettings, String description, ParameterValueOrFieldReference[] parameters, DataRetrievalPlan dataSettings)
at Microsoft.ReportingServices.Library.SetSubscriptionPropertiesAction.PerformActionNow()
at Microsoft.ReportingServices.Library.RSSoapAction`1.Execute()
--- End of inner exception stack trace ---
at Microsoft.ReportingServices.Library.RSSoapAction`1.Execute()
at Microsoft.ReportingServices.WebServer.ReportingService2005Impl.SetSubscriptionProperties(String SubscriptionID, ExtensionSettings ExtensionSettings, Boolean isDataDriven, DataRetrievalPlan DataRetrievalPlan, String Description, String EventType, String MatchData, ParameterValueOrFieldReference[] Parameters)
--- End of inner exception stack trace ---
at Microsoft.ReportingServices.WebServer.ReportingService2005Impl.SetSubscriptionProperties(String SubscriptionID, ExtensionSettings ExtensionSettings, Boolean isDataDriven, DataRetrievalPlan DataRetrievalPlan, String Description, String EventType, String MatchData, ParameterValueOrFieldReference[] Parameters)
at Microsoft.ReportingServices.WebServer.ReportingService2005.SetDataDrivenSubscriptionProperties(String DataDrivenSubscriptionID, ExtensionSettings ExtensionSettings, DataRetrievalPlan DataRetrievalPlan, String Description, String EventType, String MatchData, ParameterValueOrFieldReference[] Parameters)
w3wp!ui!b!6/14/2007-12:08:23:: e ERROR: HTTP status code --> 200
-------Details--------
Why the error is coming:
"An internal error occurred on the report server. See the error log for more details. (rsInternalError)"
Has anyone come across error 8630 "Internal Query Processor Error: The query processor encountered an unexpected error during execution." with SQL Server 7 with SP4 installed?
There are microsoft articles on the error, but the errors are suposidly fixed in SQL Server 7 SP2 and SP3.
We are selecting from one view left outer joined with another, but no unions are involved.
This is not a problem in SQL Server 2000, but unfortunatlely Microsoft are supporting SQL Server 7 until 2005 and so we have to do the same...
Hai friends,
I was created report with 9 sub reports , with multiple column driildown for based on client requirement, iam displying the correct data and in database server data is availabel between 11/01/2007 to 11/30/2007, iam applying the input parameters are begin date, end date, region(defaultly ALL), Department(defaulty ALL), site(defaulty ALL).
my problem is while selecting the default dates (minum and maximum dateranges) with selecting ALL regions, ALL departments, ALL sites iam not getting the output. it showing error like
" An error occur on local report processing, an internal error occur on report server, see error log for more details"
but iam selecting the date as 11/01/2007 to 11/02/2007( that is not large records, between two dates only) it shows correct output.
while applying the default ranges that is 11/01/2007 to 11/30/2007 report shows above mentioned error.
problem with 9 sub reports ? or any thying
please help me how to solve my problem next coming two days i have to deploy my report to client, at the time it will show data between default date ranges.
Help me thanks in advance
JACKS V
Well, I get the elusive error...
An internal error occurred on the report server. See the error log for more details.
I was trying to preview my report and this keeps coming up. I go to the logfiles to see what may be the issue and there are no errors in the log files(s). Can someone let me know what the usual path or name of the error log this is supposed to write to.
much appreciated,
Clint
I have rs2005 installed. I created some reports through SQL Server Business Intelligence Development Studio. I can preview reports fine in the studio. But after deploying it, on //localhost/reports, when I click the report, it takes a while to calculate and then give me error: "An internal error occurred on the report server. See the error log for more details. "
The weird thing is if I restart report service, it will display report fine on the first time, then fail on the following attempts.
Here is what's in the log file SQLDUMPER_ERRORLOG.log
03/20/06 16:48:18, ERROR , SQLDUMPER_UNKNOWN_APP.EXE, AdjustTokenPrivileges () failed (00000514)
03/20/06 16:48:18, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Input parameters: 4 supplied
03/20/06 16:48:18, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ProcessID = 3808
03/20/06 16:48:18, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ThreadId = 0
03/20/06 16:48:18, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Flags = 0x0
03/20/06 16:48:18, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, MiniDumpFlags = 0x0
03/20/06 16:48:18, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, SqlInfoPtr = 0x000000004740E608
03/20/06 16:48:18, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, DumpDir = <NULL>
03/20/06 16:48:18, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ExceptionRecordPtr = 0x0000000000000000
03/20/06 16:48:18, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ContextPtr = 0x0000000000000000
03/20/06 16:48:18, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ExtraFile = <NULL>
03/20/06 16:48:18, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, InstanceName = <NULL>
03/20/06 16:48:18, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ServiceName = <NULL>
03/20/06 16:48:20, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Callback type 7 not used
03/20/06 16:48:20, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, MiniDump completed: C:Program FilesMicrosoft SQL ServerMSSQL.3Reporting ServicesLogFilesSQLDmpr0038.mdmp
03/20/06 16:48:20, ACTION, w3wp.exe, Watson Invoke: No
03/20/06 16:49:09, ERROR , SQLDUMPER_UNKNOWN_APP.EXE, AdjustTokenPrivileges () failed (00000514)
03/20/06 16:49:09, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Input parameters: 4 supplied
03/20/06 16:49:09, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ProcessID = 3808
03/20/06 16:49:09, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ThreadId = 0
03/20/06 16:49:09, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Flags = 0x0
03/20/06 16:49:09, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, MiniDumpFlags = 0x0
03/20/06 16:49:09, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, SqlInfoPtr = 0x00000000086E2CF8
03/20/06 16:49:09, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, DumpDir = <NULL>
03/20/06 16:49:09, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ExceptionRecordPtr = 0x0000000000000000
03/20/06 16:49:09, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ContextPtr = 0x0000000000000000
03/20/06 16:49:09, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ExtraFile = <NULL>
03/20/06 16:49:09, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, InstanceName = <NULL>
03/20/06 16:49:09, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ServiceName = <NULL>
03/20/06 16:49:12, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Callback type 7 not used
03/20/06 16:49:12, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, MiniDump completed: C:Program FilesMicrosoft SQL ServerMSSQL.3Reporting ServicesLogFilesSQLDmpr0039.mdmp
03/20/06 16:49:12, ACTION, w3wp.exe, Watson Invoke: No
03/20/06 16:49:46, ERROR , SQLDUMPER_UNKNOWN_APP.EXE, AdjustTokenPrivileges () failed (00000514)
03/20/06 16:49:46, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Input parameters: 4 supplied
03/20/06 16:49:46, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ProcessID = 3808
03/20/06 16:49:46, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ThreadId = 0
03/20/06 16:49:46, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Flags = 0x0
03/20/06 16:49:46, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, MiniDumpFlags = 0x0
03/20/06 16:49:46, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, SqlInfoPtr = 0x00000000086E4128
03/20/06 16:49:46, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, DumpDir = <NULL>
03/20/06 16:49:46, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ExceptionRecordPtr = 0x0000000000000000
03/20/06 16:49:46, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ContextPtr = 0x0000000000000000
03/20/06 16:49:46, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ExtraFile = <NULL>
03/20/06 16:49:46, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, InstanceName = <NULL>
03/20/06 16:49:46, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ServiceName = <NULL>
03/20/06 16:49:48, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Callback type 7 not used
03/20/06 16:49:48, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, MiniDump completed: C:Program FilesMicrosoft SQL ServerMSSQL.3Reporting ServicesLogFilesSQLDmpr0040.mdmp
03/20/06 16:49:48, ACTION, w3wp.exe, Watson Invoke: No
Here is what is in SQL Dumpr0040.log:
<Header>
<Product>Microsoft SQL Server Reporting Services Version 9.00.1399.00</Product>
<Locale>en-US</Locale>
<TimeZone>Pacific Standard Time</TimeZone>
<Path>C:Program FilesMicrosoft SQL ServerMSSQL.3Reporting ServicesLogFilesReportServer__03_20_2006_16_48_01.log</Path>
<SystemName>MSI-SQL01</SystemName>
<OSName>Microsoft Windows NT 5.2.3790 Service Pack 1</OSName>
<OSVersion>5.2.3790.65536</OSVersion>
</Header>
w3wp!webserver!1!3/20/2006-16:48:02:: i INFO: Reporting Web Server started
w3wp!library!1!3/20/2006-16:48:02:: i INFO: Initializing ConnectionType to '0' as specified in Configuration file.
w3wp!library!1!3/20/2006-16:48:02:: i INFO: Initializing IsSchedulingService to 'True' as specified in Configuration file.
w3wp!library!1!3/20/2006-16:48:02:: i INFO: Initializing IsNotificationService to 'True' as specified in Configuration file.
w3wp!library!1!3/20/2006-16:48:02:: i INFO: Initializing IsEventService to 'True' as specified in Configuration file.
w3wp!library!1!3/20/2006-16:48:02:: i INFO: Initializing PollingInterval to '10' second(s) as specified in Configuration file.
w3wp!library!1!3/20/2006-16:48:02:: i INFO: Initializing WindowsServiceUseFileShareStorage to 'False' as specified in Configuration file.
w3wp!library!1!3/20/2006-16:48:02:: i INFO: Initializing MemoryLimit to '60' percent as specified in Configuration file.
w3wp!library!1!3/20/2006-16:48:02:: i INFO: Initializing RecycleTime to '720' minute(s) as specified in Configuration file.
w3wp!library!1!3/20/2006-16:48:02:: i INFO: Initializing MaximumMemoryLimit to '80' percent as specified in Configuration file.
w3wp!library!1!3/20/2006-16:48:02:: i INFO: Initializing MaxAppDomainUnloadTime to '30' minute(s) as specified in Configuration file.
w3wp!library!1!3/20/2006-16:48:02:: i INFO: Initializing MaxQueueThreads to '0' thread(s) as specified in Configuration file.
w3wp!library!1!3/20/2006-16:48:02:: i INFO: Initializing IsWebServiceEnabled to 'True' as specified in Configuration file.
w3wp!library!1!3/20/2006-16:48:02:: i INFO: Initializing MaxActiveReqForOneUser to '20' requests(s) as specified in Configuration file.
w3wp!library!1!3/20/2006-16:48:02:: i INFO: Initializing MaxScheduleWait to '5' second(s) as specified in Configuration file.
w3wp!library!1!3/20/2006-16:48:02:: i INFO: Initializing DatabaseQueryTimeout to '120' second(s) as specified in Configuration file.
w3wp!library!1!3/20/2006-16:48:02:: i INFO: Initializing ProcessRecycleOptions to '0' as specified in Configuration file.
w3wp!library!1!3/20/2006-16:48:02:: i INFO: Initializing RunningRequestsScavengerCycle to '60' second(s) as specified in Configuration file.
w3wp!library!1!3/20/2006-16:48:02:: i INFO: Initializing RunningRequestsDbCycle to '60' second(s) as specified in Configuration file.
w3wp!library!1!3/20/2006-16:48:02:: i INFO: Initializing RunningRequestsAge to '30' second(s) as specified in Configuration file.
w3wp!library!1!3/20/2006-16:48:02:: i INFO: Initializing CleanupCycleMinutes to '10' minute(s) as specified in Configuration file.
w3wp!library!1!3/20/2006-16:48:02:: i INFO: Initializing DailyCleanupMinuteOfDay to default value of '120' minutes since midnight because it was not specified in Configuration file.
w3wp!library!1!3/20/2006-16:48:02:: i INFO: Initializing WatsonFlags to '1064' as specified in Configuration file.
w3wp!library!1!3/20/2006-16:48:02:: i INFO: Initializing WatsonDumpOnExceptions to 'Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException,Microsoft.ReportingServices.Modeling.InternalModelingException' as specified in Configuration file.
w3wp!library!1!3/20/2006-16:48:02:: i INFO: Initializing WatsonDumpExcludeIfContainsExceptions to 'System.Data.SqlClient.SqlException,System.Threading.ThreadAbortException' as specified in Configuration file.
w3wp!library!1!3/20/2006-16:48:02:: i INFO: Initializing SecureConnectionLevel to '0' as specified in Configuration file.
w3wp!library!1!3/20/2006-16:48:02:: i INFO: Initializing DisplayErrorLink to 'True' as specified in Configuration file.
w3wp!library!1!3/20/2006-16:48:02:: i INFO: Initializing WebServiceUseFileShareStorage to 'False' as specified in Configuration file.
w3wp!resourceutilities!1!3/20/2006-16:48:02:: i INFO: Reporting Services starting SKU: Enterprise
w3wp!resourceutilities!1!3/20/2006-16:48:02:: i INFO: Evaluation copy: 0 days left
w3wp!runningjobs!1!3/20/2006-16:48:02:: i INFO: Database Cleanup (Web Service) timer enabled: Next Event: 600 seconds. Cycle: 600 seconds
w3wp!runningjobs!1!3/20/2006-16:48:02:: i INFO: Running Requests Scavenger timer enabled: Next Event: 60 seconds. Cycle: 60 seconds
w3wp!runningjobs!1!3/20/2006-16:48:02:: i INFO: Running Requests DB timer enabled: Next Event: 60 seconds. Cycle: 60 seconds
w3wp!runningjobs!1!3/20/2006-16:48:02:: i INFO: Memory stats update timer enabled: Next Event: 60 seconds. Cycle: 60 seconds
w3wp!library!1!03/20/2006-16:48:05:: i INFO: Call to GetPermissions:/
w3wp!library!1!03/20/2006-16:48:05:: i INFO: Catalog SQL Server Edition = Enterprise
w3wp!library!5!03/20/2006-16:48:05:: i INFO: Call to GetSystemPermissions
w3wp!library!1!03/20/2006-16:48:08:: i INFO: Call to GetPermissions:/StockSelfServie_Reports
w3wp!library!5!03/20/2006-16:48:09:: i INFO: Call to GetSystemPermissions
w3wp!library!1!03/20/2006-16:48:10:: i INFO: Call to GetPermissions:/StockSelfServie_Reports/ESPP_Withdraw
w3wp!library!1!03/20/2006-16:48:10:: i INFO: Call to GetSystemPermissions
w3wp!library!1!03/20/2006-16:48:12:: i INFO: Call to RenderFirst( '/StockSelfServie_Reports/ESPP_Withdraw' )
w3wp!library!1!03/20/2006-16:48:13:: Using folder C:Program FilesMicrosoft SQL ServerMSSQL.3Reporting ServicesRSTempFiles for temporary files.
w3wp!webserver!1!03/20/2006-16:48:15:: i INFO: Processed report. Report='/StockSelfServie_Reports/ESPP_Withdraw', Stream=''
w3wp!library!5!03/20/2006-16:48:17:: i INFO: Call to GetPermissions:/StockSelfServie_Reports
w3wp!library!5!03/20/2006-16:48:17:: i INFO: Call to GetSystemPermissions
w3wp!library!1!03/20/2006-16:48:18:: i INFO: Call to GetPermissions:/StockSelfServie_Reports/ESPP_Withdraw
w3wp!library!1!03/20/2006-16:48:18:: i INFO: Call to GetSystemPermissions
w3wp!library!1!03/20/2006-16:48:18:: i INFO: Call to RenderFirst( '/StockSelfServie_Reports/ESPP_Withdraw' )
w3wp!processing!1!03/20/2006-16:48:18:: 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, 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!1!03/20/2006-16:48:18:: 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/20/2006-16:48:20:: i INFO: Exception dumped to: C:Program FilesMicrosoft SQL ServerMSSQL.3Reporting ServicesLogFiles flags= ReferencedMemory, AllThreads, SendToWatson
w3wp!webserver!1!03/20/2006-16:48:21:: 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.
at Microsoft.ReportingServices.Diagnostics.Utilities.RSTraceInternal.Assert(Boolean condition, String componentName)
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.UpdateTimingInformation(RunningJobContext jobContext, Int64 totalDurationMs, Int64 reportDataRetrievalDurationMs, Int64 reportRenderingDurationMs)
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RenderReport(IRenderingExtension renderer, DateTime executionTimeStamp, GetReportChunk getCompiledDefinitionCallback, ProcessingContext pc, RenderingContext rc, CreateReportChunk cacheDataCallback, Boolean& dataCached)
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RenderReport(DateTime executionTimeStamp, GetReportChunk getCompiledDefinitionCallback, ProcessingContext pc, RenderingContext rc)
at Microsoft.ReportingServices.Library.RSService.RenderAsLive(CatalogItemContext reportContext, ItemProperties properties, ParameterInfoCollection effectiveParameters, Guid reportId, ClientRequest session, String description, ReportSnapshot intermediateSnapshot, DataSourceInfoCollection thisReportDataSources, Boolean cachingRequested, Warning[]& warnings, ReportSnapshot& resultSnapshotData, DateTime& executionDateTime, RuntimeDataSourceInfoCollection& alldataSources, UserProfileState& usedUserProfile)
at Microsoft.ReportingServices.Library.RSService.RenderAsLiveOrSnapshot(CatalogItemContext reportContext, ClientRequest session, Warning[]& warnings, ParameterInfoCollection& effectiveParameters)
at Microsoft.ReportingServices.Library.RSService.RenderFirst(CatalogItemContext reportContext, ClientRequest session, Warning[]& warnings, ParameterInfoCollection& effectiveParameters, String[]& secondaryStreamNames)
at Microsoft.ReportingServices.Library.RenderFirstCancelableStep.Execute()
at Microsoft.ReportingServices.Diagnostics.CancelablePhaseBase.ExecuteWrapper()
--- End of inner exception stack trace ---
at Microsoft.ReportingServices.Diagnostics.CancelablePhaseBase.ExecuteWrapper()
at Microsoft.ReportingServices.Library.RenderFirstCancelableStep.RenderFirst(RSService rs, CatalogItemContext reportContext, ClientRequest session, JobType type, Warning[]& warnings, ParameterInfoCollection& effectiveParameters, String[]& secondaryStreamNames)
at Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderReport(HttpResponseStreamFactory streamFactory)
at Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.DoStreamedOperation(StreamedOperation operation)
at Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPageContent()
at Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPage()
w3wp!library!1!03/20/2006-16:48:24:: i INFO: Call to GetPermissions:/StockSelfServie_Reports
w3wp!library!1!03/20/2006-16:48:24:: i INFO: Call to GetSystemPermissions
w3wp!library!1!03/20/2006-16:48:30:: i INFO: Call to GetPermissions:/StockSelfServie_Reports/ESPP_Enrollment
w3wp!library!1!03/20/2006-16:48:30:: i INFO: Call to GetSystemPermissions
w3wp!library!1!03/20/2006-16:48:30:: i INFO: Call to RenderFirst( '/StockSelfServie_Reports/ESPP_Enrollment' )
w3wp!webserver!1!03/20/2006-16:48:30:: i INFO: Processed report. Report='/StockSelfServie_Reports/ESPP_Enrollment', Stream=''
w3wp!library!5!03/20/2006-16:48:37:: i INFO: Call to RenderNext( '/StockSelfServie_Reports/ESPP_Enrollment' )
w3wp!cache!5!03/20/2006-16:48:37:: i INFO: Session live: /StockSelfServie_Reports/ESPP_Enrollment
w3wp!webserver!5!03/20/2006-16:48:37:: i INFO: Processed report. Report='/StockSelfServie_Reports/ESPP_Enrollment', Stream=''
w3wp!library!5!03/20/2006-16:48:38:: i INFO: Call to RenderNext( '/StockSelfServie_Reports/ESPP_Enrollment' )
w3wp!cache!5!03/20/2006-16:48:38:: i INFO: Session live: /StockSelfServie_Reports/ESPP_Enrollment
w3wp!webserver!5!03/20/2006-16:48:38:: i INFO: Processed report. Report='/StockSelfServie_Reports/ESPP_Enrollment', Stream=''
w3wp!library!5!03/20/2006-16:48:38:: i INFO: Call to RenderNext( '/StockSelfServie_Reports/ESPP_Enrollment' )
w3wp!cache!5!03/20/2006-16:48:38:: i INFO: Session live: /StockSelfServie_Reports/ESPP_Enrollment
w3wp!webserver!5!03/20/2006-16:48:38:: i INFO: Processed report. Report='/StockSelfServie_Reports/ESPP_Enrollment', Stream=''
w3wp!library!5!03/20/2006-16:48:39:: i INFO: Call to RenderNext( '/StockSelfServie_Reports/ESPP_Enrollment' )
w3wp!processing!5!03/20/2006-16:48:39:: 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!5!03/20/2006-16:48:39:: 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/20/2006-16:49:12:: i INFO: Exception dumped to: C:Program FilesMicrosoft SQL ServerMSSQL.3Reporting ServicesLogFiles flags= ReferencedMemory, AllThreads, SendToWatson
w3wp!webserver!5!03/20/2006-16:49:12:: 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.
at Microsoft.ReportingServices.Diagnostics.Utilities.RSTraceInternal.Assert(Boolean condition, String componentName)
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.UpdateTimingInformation(RunningJobContext jobContext, Int64 totalDurationMs, Int64 reportDataRetrievalDurationMs, Int64 reportRenderingDurationMs)
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RenderSnapshot(IRenderingExtension renderer, CreateReportChunk createChunkCallback, RenderingContext rc, GetResource getResourceCallback)
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RenderSnapshot(CreateReportChunk createChunkCallback, RenderingContext rc, GetResource getResourceCallback)
at Microsoft.ReportingServices.Library.RenderSnapshotAction.Render()
at Microsoft.ReportingServices.Library.RSService.RenderFromSessionNoCache(CatalogItemContext reportContext, ClientRequest session, RenderingResult& result)
at Microsoft.ReportingServices.Library.RSService.RenderFromSession(CatalogItemContext reportContext, ClientRequest session, Warning[]& warnings, ParameterInfoCollection& effectiveParameters)
at Microsoft.ReportingServices.Library.RSService.RenderNext(CatalogItemContext reportContext, ClientRequest session, Warning[]& warnings, ParameterInfoCollection& effecectiveParameters, String[]& secondaryStreamNames)
at Microsoft.ReportingServices.Library.RenderNextCancelableStep.Execute()
at Microsoft.ReportingServices.Diagnostics.CancelablePhaseBase.ExecuteWrapper()
--- End of inner exception stack trace ---
at Microsoft.ReportingServices.Diagnostics.CancelablePhaseBase.ExecuteWrapper()
at Microsoft.ReportingServices.Library.RenderNextCancelableStep.RenderNext(RSService rs, CatalogItemContext reportContext, ClientRequest session, JobType type, Warning[]& warnings, ParameterInfoCollection& effectiveParameters, String[]& secondaryStreamNames)
at Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderReport(HttpResponseStreamFactory streamFactory)
at Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.DoStreamedOperation(StreamedOperation operation)
at Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPageContent()
at Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPage()
w3wp!library!5!03/20/2006-16:49:14:: i INFO: Call to GetPermissions:/StockSelfServie_Reports
w3wp!library!5!03/20/2006-16:49:14:: i INFO: Call to GetSystemPermissions
w3wp!library!5!03/20/2006-16:49:16:: i INFO: Call to GetPermissions:/StockSelfServie_Reports/ESPP_Change
w3wp!library!5!03/20/2006-16:49:16:: i INFO: Call to GetSystemPermissions
w3wp!library!5!03/20/2006-16:49:16:: i INFO: Call to RenderFirst( '/StockSelfServie_Reports/ESPP_Change' )
w3wp!processing!5!03/20/2006-16:49:16:: 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, 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/20/2006-16:49:16:: 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.
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
</code>
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?
Any help is greatly appreciated.
Thanks.
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.
View 6 Replies View RelatedServer: 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.
Line 890 has:
INSERT INTO #tmpResults (
We are on SQL Server 2000 SP4 (8.00.2187)....
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
View 5 Replies View RelatedHi,
I am running into this error when running 2 *very* similar packages, however I only get the error on pkg2, not pkg1.
pkg1:
flat file source --> dts 200 package --> oledb destination
pkg2:
flat file source --> script component --> oledb destination
At the very end of the flat file there is a partial row. The second package raises an error when it finds this row. However, pkg1 does not. It runs perfectly every morning.
[Flat File Source [799]] Warning: There is a partial row at the end of the file.
If I remove the row, of course it works. But I don't have the option of removing this row.
So my questions are, 1) why does the first pkg1 not raise an error on this row?
2) how can I redirect bad rows to another location, or skip them completely, as in this case?
Thanks
When we try to run aggregation or purge queries on some tables
we are getting following message:
" error [I/O error (bad page ID) detected during read at offset 0x000001ad65a000 in file 'E:MSSQL2KDataGenesys_DataMartGenesys_Datamart.mdf '. Severity 24, State 2, Procedure 'PWMGENESYSDB1 n u! ll', Line 1]"
After this we executed DBCC CHECKDB. Attaching the output obtained after executing this command, to fix these errors we executed DBCC repair_allow_data_loss. I am attaching output for this also. Pls go thru the logs and pls let me know what could be the problem and how it can be addressed.
Thnx & Rgds
Malla
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?
View 2 Replies View RelatedMy apologies...I wasn't for sure where to post an error like this...
Over the last 2 months I have gotten this SQL Server error (twice). All existing processes will continue to work, however no new processes can be created and users cannot connect to the server. This is the exact text of the message in the SQL Server error log.
Operating system error 10038: An operation was attempted on something that is not a socket...
Error: 17059, Severity: 18, State: 0
Error accepting connection request via Net-Library 'SSNETLIB'. Execution continuing.
Error: 17882, Severity: 18, State:
While we can typically just stop SQL Server Service and restart the services...I have found it is best to restart the machine during non-production times to take care of any 'residual' effects of this error.
The SQL Server 2000 SP4 box with Windows 2003 Standard SP1 is well maintained by our I.T. team and it typically will run 4 or 5 months without a reboot.
Thank you...
...cordell...