Using the following code we are having a problem connecting a clients WIndows Mobile device to the SDF under IIS. We have success elsewhere. Does anyone have any clues ?
The application uses Merge Replication. The error occurs in the Synchronise() Method of the SqlCeReplication object.
"SQL Server Mobile encountered problems when opening the database."
repl.AddSubscription(AddOption.ExistingDatabase) repl.Synchronize() I also checked the the connection string and it seems to be fine. Both my device and server can ping each other. Moreever I can also access the Web syncronization folder(on server) from the device.Is anyone having a resolution for this?
Hello! I'm trying to connect a sql ce database from a PPC with WM 2003 to a sql server 2005 database.
I discover the class SqlCeRemoteDataAccess, so i've been trying, unsucessfuly, to get things working.
I googled a lot, i read Ms Articles from MSDN, i read some posts here, but can't find solution for my problem. As you can see in my code, i already tryed different aprroaches, differente connections strings, with "provider", without "provider", with "sspi", without "sspi", you name it...
I configure the sql server agent like i read in msdn, and he's working well, i'm able to see the message. ("Microsoft SQL Server Compact Edition Server Agent" when i open the url).
The sql database credentials are correct, i already check that.
I did everything i knew and i read, unfortunately i still can't manage to find a solution for an error message:
"SQL Server Mobile encountered problems when opening the database." The native error is 28559
That's an Exception error message, that appears to me.
The application uses Merge Replication. The error occurs in the Synchronise() Method of the SqlCeReplication object.
"SQL Server Mobile encountered problems when opening the database."
repl.AddSubscription(AddOption.ExistingDatabase) repl.Synchronize() I also checked the the connection string and it seems to be fine. Both my device and server can ping each other. Moreever I can also access the Web syncronization folder(on server) from the device.Is anyone having a resolution for this?
I'll try and ask one more time. Does anyone have a clue how to fix this?
"A SQL Server Compact Edition DLL could not be loaded. Reinstall SQL Server Compact Edition. [ DLL Name = sqlceca30.dll ]"
or
"SQL Server Compact Edition encountered problems when opening the database" "Internal error: The database is not initialized."
I've been fighting this for well over a week now. My XP based version works fine but this error occurs routinely on my CE4.2 device. I cannot find anything meaningful using Google other than 'look for non disposed' replication objects which I've done. Is this bad hardware? I don't believe I'm out of memory as the app is about 1.2MB including about 8 DLL's and GC indicates I have about 300KB of objects at the time of the failure. I also use a bunch of static (global) objects that I use throughout the code.
It would be nice if I could get the lower level error messages causing these failures but that is probably too much to ask.
The odd thing is that it's only the replication engine that fails as even after the failure, the app can reopen the DB and work with the data just fine.
My basic order of the application is...
1 Open DB SqlCEConnection 2 Create/Prepare any SqlCECommand objects 3 Do work here 4 Dispose any SqlCECommand objects 5 Close DB 6 Dispose SqlCEConnection object 7 Create SqlCEReplication object 8 BeginSynchronize 9 ... error here.. 10 Dispose SqlCEReplication object 11 Reopen DB SqlCEConnection
I've tried creating the Replication object at program start and that does not help. I'm guessing there is something about .net that I don't understand either with stack space, # dll's or whatever. I've rearranged the order of the Dispose, Create, SQL CE objects to include just about every permutation but still am hitting this same problem.
Are there any tools that can help me profile this app for memory problems or usage? Everything seems geared for .Net and not .NetCF.
Hi,I am getting this error when i am connecting sql database.Error = "SQL Server does not exist or access denied."Can you please suggest me where i am going wrong.RegardsNaveen
I am trying to call a stored procedure to insert into my database. After I called Open(), it crashed on ExecuteNonQuery(). I get the following message.
Object must implement IConvertible. Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.InvalidCastException: Object must implement IConvertible.
Source Error:
Line 160:Try Line 161:myConnection.Open() Line 162:myCommand.ExecuteNonQuery() Line 163:myConnection.Close()
What does this mean? If anyone encountered this error before, please let me know how to trace the error and fix it.
suggested that this problem could be circumvented by getting the replication object early and then continuously using the same object for subsequent replications.
I did this and it works a lot better now but ever so often I get another error which is
Native Error 28559 SQL Mobile encountered problems when opening the database
My only option at this point is to stop and start the application which cures the problem.
We are using sql server 2005 Enterprise Edition with service pack1
I got the following error messages in the SQL log
The operating system returned error 21(The device is not ready.) to SQL Server during a read at offset 0x00000000090000 in file '....mdf'. Additional messages in the SQL Server error log and system event log may provide more detail. This is a severe system-level error condition that threatens database integrity and must be corrected immediately. Complete a full database consistency check (DBCC CHECKDB). This error can be caused by many factors; for more information, see SQL Server Books Online. fcb::close-flush: Operating system error 21(The device is not ready.) encountered.
I got these errors for about 2 hrs and after that I see these messages in the sql log
Starting up database ' ' 1 transactions rolled forward in database '' (). This is an informational message only. No user action is required. 0 transactions rolled back in database ' ' (). This is an informational message only. No user action is required. Recovery is writing a checkpoint in database ' ' ( ). This is an informational message only. No user action is required. CHECKDB for database '' finished without errors on (local time). This is an informational message only; no user action is required.
Can anyone please help me in troubleshooting this issue. Why this migh have happened.
I have recently installed a new server for a client running SBS2003 R2 with SQLServer 2005.
I noted that the backup failed the SQL Server database on the consistenty check. On checking the event log I see this message as per above.
It reads in the description
c:datalawsqldatadata41_Data.MDF:MSSQL_DBCC6:
Operating system error 112(error not found) encountered.
Looking in the error log I see :
Configuration option 'user options' changed from 0 to 0. Run the RECONFIGURE statement to install.
Error: 17053, Severity: 16, State: 1.
C:DataLAWsqldatadata41_Data.MDF:MSSQL_DBCC6: Operating system error 112(error not found) encountered.
DBCC CHECKDB (data41) WITH no_infomsgs executed by NT AUTHORITYSYSTEM found 0 errors and repaired 0 errors. Elapsed time: 0 hours 0 minutes 26 seconds.
This is a new server with about 90% of disk space NTFS still available
I receive error 25123 on my PPC (audiovox 6600) in a reproducable way (usually) with .net 2.0 application that is using SQL CE that I wrote:
Open the application Connect to the database Close the applicaton Re-Open the application Connect to the database <-- Error occurs
I will also receive the error if my application isn't the first application launched (or very close to the first to launch).
I don't believe it's a memory issue as according to the memory manager I have plenty of memory:
At boot up only start screen items loaded: 18.46 Used 49.89 Free Launch Resco File Explorer to click EXE: 19.18 Used 49.18 Free Launch my application (no DB connection): 23.64 Used 44.71 Free Connect to the DB and do select count(*) from a table with 0 rows: 26.27 Used 42.08 Free Close the application (this.Close() on the form: 19.38 Used 48.97 Free Relaunch App and connect to DB receive error: around 38 Used around 30 free
I was unable to reproduce the issue right now while typing this message, the last sets of numbers are from memory, and include other applications that are currently running.
The only way I have to get SQL CE to load again is to soft reset the PPC. If the application is able to connect to SQL CE at least once it is fine up till I close it and re-open the application. So it either connects and runs great, or it can't connect at all.
Any help in resolving this issue would be greatly appreciated. Wayne
This is a problem I encountered when I had to detach a database file (type .mdf):
1) I went to the MS SQL Management Server Studi and detached my database file successfully from a connection called Workhorse.
2) I needed to place the .mdf database file into a zip file in order to put it on a remote server. I did this using Shared Portal. This was also successful
3) However when I tried reattaching the database file, I got this error:
CREATE FILE encountered operating system error 5A(Access denied.) while attempting to open or create the physical file "CProgram FilesMSSQL ServerMSSQLData<databasename>.mdf'
Q) The database file and log file (ldf) exist in the correct directory so I don't know what happened. Can any one help?
Good day good people of the forum while carrying out a remote installation i encountered an UNC path error can anyone be of help giving me a comprehensive answer to the problem. am stuck i cant move ahead from that part of the installation
Please provide some help regarding the "Interface Defining Error: IID_IDBDataSourceAdmin" error while trying to create a SDF database using Query Analyzer on a Windows CE 5.0 mobile device (Symbol MC3000).
Error: 0x80004005 E_FAIL Native Error: 28558 Description: SQL Mobile encountered problems when creating database [,,,,]
PS. Basically I have developed a mobile application that programmatically creates the database, the code worked on a similar device (Win CE 50), trying to run the application on a new device resulted in database creation errors. I tried creating a test database manually .. and this is what I got.
Browsing MSDN or searching on the Forum did not help.
The development environment & the SQL Box are two different boxes.
I am trying to create a simple application where I want to synchronize data between Pocket PC application's ( Emulator) local database(SQL Mobile) to SQL 2005 Database. I have tried the steps outlined in the following link
Once I have completed all the steps as per the steps in the above link, I have copied the .sdf file to an another machine where I have the development environment. I have created a device application in VS 2005 and created a datasource poiting to the file (.sdf) copied locally.
Then I have added the following code string filename = @"e:VelsunMobileTest.sdf";
if (VelsunMobileTestDataSetUtil.DesignerUtil.IsRunTime()) { // TODO: Delete this line of code to remove the default AutoFill for 'velsunMobileTestDataSet.Customers'. this.customersTableAdapter.Fill(this.velsunMobileTestDataSet.Customers); }
}
private void DeleteDB() { if (System.IO.File.Exists(filename)) { System.IO.File.Delete(filename); } }
private void Sync() { SqlCeReplication repl = new SqlCeReplication();
I have one table with columns patientName , Nurse,ArrivalDate, DepartDate . It has all the patiet information for all the Nurses.
I am calculating Average Number of patients per day per nurse by using below query
SELECT Nurse, COUNT(DISTINCT patientName) AS NoOfPatients, COUNT(DISTINCT patientName) * 1.0/COUNT(DISTINCT ArrivalDate) AS [AvgNo.ofpatientsPerDay] FROM Table t GROUP BY NURSE
but if ArrivalDate is Null I am getting below error saying that Divide by zero error encountered.
we now used synonyms on the version 6 of our peoject, at first it turns out good. Then we migrate a database to the new database, everythings fine, its just a data migration anyway. The target database' structure and DML's wasn't change during migration. then intermittendly, we're encountering "A severe error occurred on the current command. The results, if any, should be discarded". I said its intermittent because sometime its ok, mostly its not functioning.
This is very painfull because all our scripts has this synonym. All our scripts uses an sp execution logging stored procedured of another database so we created a synonym for those sp's instead of fully qualifying the procedure name.
This is a major issue for us, please advise. You may response here, send me email or email me. Many Thanks.
Rodel E. Dagumampan Email: dehranph@gmail.com Yahoo: dehranph Blog: http://community.devpinoy.org/blogs/dehranph
SELECT Client,State, CASE WHEN Weight>=11 and Weight<=455 and Height>=110 and Height<=250 THEN isnull((cast(nullif(Weight,0)/power((NullIf(Weight,0)/100),2) as int)),0) else -1 end as BaseBMIScore FROM Test100
And I got following error:
Msg 8134, Level 16, State 1, Line 1 Divide by zero error encountered.
When i exec an sp it runs a sum, sometimes it is possible that there is a 0 value, it then returns an error Divide by zero error encountered How can i work around this error
My sp code is
CREATE proc CP_avgloss_rings @mID varchar(10), @startdate datetime, @enddate datetime as select ((sum(vtp)-(sum(moneyout)))/100) / ((sum(playtime))/ 3600) as avgloss from dbo.rings where machineID = @mID and convert(varchar,njdate,121) between convert(varchar,@startdate,121) and convert(varchar,@enddate,121) GO
I have a dtsx import script which import a delimeted csv file into a sql 2012 table. The default of the output length for all columns is set to 50 characters.All records which do not comply goes to another table in the same database. When I ran the script,all the records goes to the error table. I have now found a way to retrieve the column id and the error message to find that some column are been truncated and do not import.
I now need to know which column is given the error. The import file have more than 300 columns and I do not want to go and check each column length.I am using visual studio 2010 and using visual basic. I have found a sample of C+,but the screen shots is very small and when I type in the command,i do not compile.
We have over 400 import scripts and I could really use this in all of them to trouble shoot.
I installed SQL Server 2005 Integration services on Windows XP machine. Then I went to the SQL Server Configuration Manager and tried to Start the SSIS service. The "Log On As" value is "NT AUTHORITYNetworkService". But I get the follwoing error:
The request failed or the service did not respond in a timely fashion. COnsult the event log or other applicable error logs for details.
Event Log details: ------------------ The SQL Server Integration Services service failed to start due to the following error: The service did not respond to the start or control request in a timely fashion.
For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
I tried running the service using the "Local Service" and the "Local System" accounts also, but am still encountering the same error. What do I do...
Good day good people of the forum thanks for the response this is the error message i encountered "an error occured while attempting to validate the setup source files unc path. verify that you have entered a valid unc path."
I export data from a dozen tables of one database to another database on another server regularly and it works well. However, if i choose the option of "save SSIS package", I get the following error:
TITLE: SQL Server Import and Export Wizard ------------------------------
The ExistsOnSQLServer method has encountered OLE DB error code 0x80004005 (Client unable to establish connection). The SQL statement issued has failed.
------------------------------ BUTTONS:
OK ------------------------------
I use management studio to do this, but the servers are 2000.
I encountered an error when attempting to install Visual Basic Express Edition RTM. During the setup, I selected MSDN Express Edition and SQL Server 2005 Express Edition. Specifically, the SQL Server 2005 EE part of the installation failed. Here's the error I received:
Visual Basic 2005 Express Edition Setup Error occurred during setup Visual Basic 2005 Express Edition has been successfully installed. The following component failed to install: Microsoft SQL Server 2005 Express Edition x86
I had not installed any betas on this particular PC; however, I had already installed Visual Studio 2005 Pro and SQL Server 2005 Developer Edition.
(I selected SQL Server EE during the VBEE install because the VBEE readme said that the VSEE Editions (except for VWD) only work with SQL Server EE--so I figured I had to install SQL Server EE if I wanted to do any database work with VBEE. Is that the case?)
The following two log files were the only ones containing any error messages. How should I proceed?
C:Program Filesmicrosoft sql server90setup bootstraplogfilesSQLSetup0003_US05046_Core.log: Microsoft SQL Server 2005 Setup beginning at Mon Dec 19 14:40:32 2005 Process ID : 5824 c:211395ac6e4ed715363fsetup.exe Version: 2005.90.1399.0 Running: LoadResourcesAction at: 2005/11/19 14:40:31 Complete: LoadResourcesAction at: 2005/11/19 14:40:31, returned true Running: ParseBootstrapOptionsAction at: 2005/11/19 14:40:31 Loaded DLL:c:211395ac6e4ed715363fxmlrw.dll Version:2.0.3604.0 Complete: ParseBootstrapOptionsAction at: 2005/11/19 14:40:32, returned true Running: ValidateWinNTAction at: 2005/11/19 14:40:32 Complete: ValidateWinNTAction at: 2005/11/19 14:40:32, returned true Running: ValidateMinOSAction at: 2005/11/19 14:40:32 Complete: ValidateMinOSAction at: 2005/11/19 14:40:32, returned true Running: PerformSCCAction at: 2005/11/19 14:40:32 Complete: PerformSCCAction at: 2005/11/19 14:40:32, returned true Running: ActivateLoggingAction at: 2005/11/19 14:40:32 Complete: ActivateLoggingAction at: 2005/11/19 14:40:32, returned true Running: DetectPatchedBootstrapAction at: 2005/11/19 14:40:32 Complete: DetectPatchedBootstrapAction at: 2005/11/19 14:40:32, returned true Action "LaunchPatchedBootstrapAction" will be skipped due to the following restrictions: Condition "EventCondition: __STP_LaunchPatchedBootstrap__5824" returned false. Running: PerformSCCAction2 at: 2005/11/19 14:40:32 Loaded DLL:C:WINNTsystem32msi.dll Version:3.1.4000.2435 Loaded DLL:C:WINNTsystem32msi.dll Version:3.1.4000.2435 Complete: PerformSCCAction2 at: 2005/11/19 14:40:33, returned true Running: PerformDotNetCheck at: 2005/11/19 14:40:33 Complete: PerformDotNetCheck at: 2005/11/19 14:40:33, returned true Running: ComponentUpdateAction at: 2005/11/19 14:40:33 Complete: ComponentUpdateAction at: 2005/11/19 14:41:6, returned true Running: DetectLocalBootstrapAction at: 2005/11/19 14:41:6 Complete: DetectLocalBootstrapAction at: 2005/11/19 14:41:6, returned true Running: LaunchLocalBootstrapAction at: 2005/11/19 14:41:6 Error: Action "LaunchLocalBootstrapAction" threw an exception during execution. Error information reported during run: "c:Program FilesMicrosoft SQL Server90Setup Bootstrapsetup.exe" finished and returned: 1706 Aborting queue processing as nested installer has completed Message pump returning: 1706
C:Program Filesmicrosoft sql server90setup bootstraplogfilesSQLSetup0003_US05046_Core(Local).log: Microsoft SQL Server 2005 Setup beginning at Mon Dec 19 14:41:10 2005 Process ID : 5476 c:Program FilesMicrosoft SQL Server90Setup Bootstrapsetup.exe Version: 2005.90.1399.0 Running: LoadResourcesAction at: 2005/11/19 14:41:9 Complete: LoadResourcesAction at: 2005/11/19 14:41:9, returned true Running: ParseBootstrapOptionsAction at: 2005/11/19 14:41:9 Loaded DLL:c:Program FilesMicrosoft SQL Server90Setup Bootstrapxmlrw.dll Version:2.0.3604.0 Complete: ParseBootstrapOptionsAction at: 2005/11/19 14:41:9, returned true Running: ValidateWinNTAction at: 2005/11/19 14:41:9 Complete: ValidateWinNTAction at: 2005/11/19 14:41:9, returned true Running: ValidateMinOSAction at: 2005/11/19 14:41:9 Complete: ValidateMinOSAction at: 2005/11/19 14:41:9, returned true Running: PerformSCCAction at: 2005/11/19 14:41:9 Complete: PerformSCCAction at: 2005/11/19 14:41:9, returned true Running: ActivateLoggingAction at: 2005/11/19 14:41:9 Complete: ActivateLoggingAction at: 2005/11/19 14:41:10, returned true Running: DetectPatchedBootstrapAction at: 2005/11/19 14:41:10 Complete: DetectPatchedBootstrapAction at: 2005/11/19 14:41:10, returned true Action "LaunchPatchedBootstrapAction" will be skipped due to the following restrictions: Condition "EventCondition: __STP_LaunchPatchedBootstrap__5476" returned false. Action "BeginBootstrapLogicStage" will be skipped due to the following restrictions: Condition "Setup is running locally." returned true. Running: PerformDotNetCheck2 at: 2005/11/19 14:41:10 Complete: PerformDotNetCheck2 at: 2005/11/19 14:41:12, returned true Running: InvokeSqlSetupDllAction at: 2005/11/19 14:41:12 Loaded DLL:c:Program FilesMicrosoft SQL Server90Setup Bootstrapsqlspars.dll Version:2005.90.1399.0 <Func Name='DwLaunchMsiExec'> Examining 'sqlspars' globals to initialize 'SetupStateScope' Opening 'MachineConfigScope' for [US05046] Trying to find Product Code from command line or passed transform If possible, determine install id and type Trying to find Instance Name from command line. No Instance Name provided on the command line If possible, determine action Machine = US05046, Article = WMIServiceWin32OSWorking, Result = 0 (0x0) Machine = US05046, Article = WMIServiceWin32CompSystemWorking, Result = 0 (0x0) Machine = US05046, Article = WMIServiceWin32ProcessorWorking, Result = 0 (0x0) Machine = US05046, Article = WMIServiceReadRegWorking, Result = 0 (0x0) Machine = US05046, Article = WMIServiceWin32DirectoryWorking, Result = 0 (0x0) Machine = US05046, Article = WMIServiceCIMDataWorking, Result = 0 (0x0) Machine = US05046, Article = XMLDomDocument, Result = 0 (0x0) Machine = US05046, Article = Processor, Result = 0 (0x0) Machine = US05046, Article = PhysicalMemory, Result = 0 (0x0) Machine = US05046, Article = DiskFreeSpace, Result = 0 (0x0) Machine = US05046, Article = OSVersion, Result = 0 (0x0) Machine = US05046, Article = OSServicePack, Result = 0 (0x0) Machine = US05046, Article = OSType, Result = 0 (0x0) Machine = US05046, Article = AdminShare, Result = 0 (0x0) Machine = US05046, Article = PendingReboot, Result = 0 (0x0) Machine = US05046, Article = IEVersion, Result = 0 (0x0) Machine = US05046, Article = DriveWriteAccess, Result = 0 (0x0) Machine = US05046, Article = COMPlus, Result = 0 (0x0) Machine = US05046, Article = ASPNETVersionRegistration, Result = 0 (0x0) ******************************************* Setup Consistency Check Report for Machine: US05046 ******************************************* Article: WMI Service Requirement, Result: CheckPassed Article: MSXML Requirement, Result: CheckPassed Article: Operating System Minimum Level Requirement, Result: CheckPassed Article: Operating System Service Pack Level Requirement, Result: CheckPassed Article: SQL Compatibility With Operating System, Result: CheckPassed Article: Minimum Hardware Requirement, Result: CheckPassed Article: Pending Reboot Requirement, Result: CheckPassed Article: Default Installation Path Permission Requirement, Result: CheckPassed Article: Internet Explorer Requirement, Result: CheckPassed Article: Check COM+ Catalogue, Result: CheckPassed Article: ASP.Net Registration Requirement, Result: CheckPassed <Func Name='PerformDetections'> 0 <EndFunc Name='PerformDetections' Return='0' GetLastError='0'> Loaded DLL:c:Program FilesMicrosoft SQL Server90Setup Bootstrapsqlsval.dll Version:2005.90.1399.0 <EndFunc Name='DwLaunchMsiExec' Return='0' GetLastError='0'> Complete: InvokeSqlSetupDllAction at: 2005/11/19 14:42:59, returned true Running: SetPackageInstallStateAction at: 2005/11/19 14:42:59 Complete: SetPackageInstallStateAction at: 2005/11/19 14:43:1, returned true Running: DeterminePackageTransformsAction at: 2005/11/19 14:43:1 Complete: DeterminePackageTransformsAction at: 2005/11/19 14:43:5, returned true Running: ValidateSetupPropertiesAction at: 2005/11/19 14:43:5 Complete: ValidateSetupPropertiesAction at: 2005/11/19 14:43:5, returned true Running: OpenPipeAction at: 2005/11/19 14:43:5 Complete: OpenPipeAction at: 2005/11/19 14:43:5, returned false Error: Action "OpenPipeAction" failed during execution. Running: CreatePipeAction at: 2005/11/19 14:43:5 Complete: CreatePipeAction at: 2005/11/19 14:43:5, returned false Error: Action "CreatePipeAction" failed during execution. Action "RunRemoteSetupAction" will be skipped due to the following restrictions: Condition "Action: CreatePipeAction has finished and passed." returned false. Running: PopulateMutatorDbAction at: 2005/11/19 14:43:5 Complete: PopulateMutatorDbAction at: 2005/11/19 14:43:5, returned true Running: GenerateRequestsAction at: 2005/11/19 14:43:5 SQL_Engine = 3 SQL_Data_Files = 3 SQL_Replication = 3 SQL_FullText = -1 SQL_SharedTools = 3 SQL_BC_DEP = -1 Analysis_Server = -1 AnalysisDataFiles = -1 AnalysisSharedTools = -1 RS_Server = -1 RS_Web_Interface = -1 RS_SharedTools = -1 Notification_Services = -1 NS_Engine = -1 NS_Client = -1 SQL_DTS = -1 Client_Components = 3 Connectivity = 3 SQL_Tools90 = -1 SQL_WarehouseDevWorkbench = -1 SDK = 3 SQLXML = -1 Tools_Legacy = -1 TOOLS_BC_DEP = -1 SQL_Documentation = -1 SQL_BooksOnline = -1 SQL_DatabaseSamples = -1 SQL_AdventureWorksSamples = -1 SQL_AdventureWorksDWSamples = -1 SQL_AdventureWorksASSamples = -1 SQL_Samples = -1 Complete: GenerateRequestsAction at: 2005/11/19 14:43:11, returned true Running: CreateProgressWindowAction at: 2005/11/19 14:43:11 Complete: CreateProgressWindowAction at: 2005/11/19 14:43:12, returned false Error: Action "CreateProgressWindowAction" failed during execution. Running: ScheduleActionAction at: 2005/11/19 14:43:12 Complete: ScheduleActionAction at: 2005/11/19 14:43:13, returned true Skipped: InstallASAction.11 Skipped: Action "InstallASAction.11" was not run. Information reported during analysis: No install request found for package: "sqlsupport", referred by package: "as", install will be skipped as a result. Skipped: InstallASAction.18 Skipped: Action "InstallASAction.18" was not run. Information reported during analysis: No install request found for package: "owc11", referred by package: "as", install will be skipped as a result. Skipped: InstallASAction.22 Skipped: Action "InstallASAction.22" was not run. Information reported during analysis: No install request found for package: "bcRedist", referred by package: "as", install will be skipped as a result. Skipped: InstallASAction.9 Skipped: Action "InstallASAction.9" was not run. Information reported during analysis: No install request found for package: "msxml6", referred by package: "as", install will be skipped as a result. Skipped: InstallDTSAction Skipped: Action "InstallDTSAction" was not run. Information reported during analysis: No install request found for package: "dts", install will be skipped as a result. Skipped: InstallDTSAction.11 Skipped: Action "InstallDTSAction.11" was not run. Information reported during analysis: No install request found for package: "sqlsupport", referred by package: "dts", install will be skipped as a result. Skipped: InstallDTSAction.12 Skipped: Action "InstallDTSAction.12" was not run. Information reported during analysis: No install request found for package: "sqlncli", referred by package: "dts", install will be skipped as a result. Skipped: InstallDTSAction.18 Skipped: Action "InstallDTSAction.18" was not run. Information reported during analysis: No install request found for package: "owc11", referred by package: "dts", install will be skipped as a result. Skipped: InstallDTSAction.22 Skipped: Action "InstallDTSAction.22" was not run. Information reported during analysis: No install request found for package: "bcRedist", referred by package: "dts", install will be skipped as a result. Skipped: InstallDTSAction.9 Skipped: Action "InstallDTSAction.9" was not run. Information reported during analysis: No install request found for package: "msxml6", referred by package: "dts", install will be skipped as a result. Skipped: InstallNSAction Skipped: Action "InstallNSAction" was not run. Information reported during analysis: No install request found for package: "ns", install will be skipped as a result. Skipped: InstallNSAction.11 Skipped: Action "InstallNSAction.11" was not run. Information reported during analysis: No install request found for package: "sqlsupport", referred by package: "ns", install will be skipped as a result. Skipped: InstallNSAction.12 Skipped: Action "InstallNSAction.12" was not run. Information reported during analysis: No install request found for package: "sqlncli", referred by package: "ns", install will be skipped as a result. Skipped: InstallNSAction.18 Skipped: Action "InstallNSAction.18" was not run. Information reported during analysis: No install request found for package: "owc11", referred by package: "ns", install will be skipped as a result. Skipped: InstallNSAction.22 Skipped: Action "InstallNSAction.22" was not run. Information reported during analysis: No install request found for package: "bcRedist", referred by package: "ns", install will be skipped as a result. Skipped: InstallNSAction.9 Skipped: Action "InstallNSAction.9" was not run. Information reported during analysis: No install request found for package: "msxml6", referred by package: "ns", install will be skipped as a result. Skipped: InstallRSAction.11 Skipped: Action "InstallRSAction.11" was not run. Information reported during analysis: No install request found for package: "sqlsupport", referred by package: "rs", install will be skipped as a result. Skipped: InstallRSAction.18 Skipped: Action "InstallRSAction.18" was not run. Information reported during analysis: No install request found for package: "owc11", referred by package: "rs", install will be skipped as a result. Skipped: InstallRSAction.22 Skipped: Action "InstallRSAction.22" was not run. Information reported during analysis: No install request found for package: "bcRedist", referred by package: "rs", install will be skipped as a result. Running: InstallSqlAction.11 at: 2005/11/19 14:43:14 Installing: sqlsupport on target: US05046 Complete: InstallSqlAction.11 at: 2005/11/19 14:43:26, returned true Running: InstallSqlAction.12 at: 2005/11/19 14:43:26 Installing: sqlncli on target: US05046 Complete: InstallSqlAction.12 at: 2005/11/19 14:43:40, returned true Skipped: InstallSqlAction.18 Skipped: Action "InstallSqlAction.18" was not run. Information reported during analysis: No install request found for package: "owc11", referred by package: "sql", install will be skipped as a result. Running: InstallSqlAction.21 at: 2005/11/19 14:43:40 Installing: sqlwriter on target: US05046 Failed to install package Fatal error during installation. Setting package return code to: 1706 Complete: InstallSqlAction.21 at: 2005/11/19 14:43:50, returned false Error: Action "InstallSqlAction.21" failed during execution. Error information reported during run: Target collection includes the local machine. Invoking installPackage() on local machine. Skipped: InstallSqlAction.22 Skipped: Action "InstallSqlAction.22" was not run. Information reported during analysis: No install request found for package: "bcRedist", referred by package: "sql", install will be skipped as a result. Running: InstallSqlAction.9 at: 2005/11/19 14:43:50 Installing: msxml6 on target: US05046 Complete: InstallSqlAction.9 at: 2005/11/19 14:43:54, returned true Running: InstallToolsAction.11 at: 2005/11/19 14:43:54 Installing: sqlsupport on target: US05046 Complete: InstallToolsAction.11 at: 2005/11/19 14:44:2, returned true Running: InstallToolsAction.12 at: 2005/11/19 14:44:2 Installing: sqlncli on target: US05046 Complete: InstallToolsAction.12 at: 2005/11/19 14:44:11, returned true Skipped: InstallToolsAction.13 Skipped: Action "InstallToolsAction.13" was not run. Information reported during analysis: No install request found for package: "PPESku", referred by package: "tools", install will be skipped as a result. Skipped: InstallToolsAction.18 Skipped: Action "InstallToolsAction.18" was not run. Information reported during analysis: No install request found for package: "owc11", referred by package: "tools", install will be skipped as a result. Skipped: InstallToolsAction.20 Skipped: Action "InstallToolsAction.20" was not run. Information reported during analysis: No install request found for package: "BOL", referred by package: "tools", install will be skipped as a result. Skipped: InstallToolsAction.22 Skipped: Action "InstallToolsAction.22" was not run. Information reported during analysis: No install request found for package: "bcRedist", referred by package: "tools", install will be skipped as a result. Running: InstallToolsAction.9 at: 2005/11/19 14:44:11 Installing: msxml6 on target: US05046 Complete: InstallToolsAction.9 at: 2005/11/19 14:44:15, returned true Action "InstallSqlAction" will return false due to the following preconditions: Condition "Action: InstallSqlAction.21 has finished and failed." returned true. Installation of package: "sql" failed due to a precondition. Step "InstallSqlAction" was not able to run. Skipped: InstallNSAction.10 Skipped: Action "InstallNSAction.10" was not run. Information reported during analysis: No install request found for package: "sqlxml4", referred by package: "ns", install will be skipped as a result. Running: InstallToolsAction at: 2005/11/19 14:44:15 Installing: tools on target: US05046 Complete: InstallToolsAction at: 2005/11/19 14:44:26, returned true Skipped: InstallToolsAction.10 Skipped: Action "InstallToolsAction.10" was not run. Information reported during analysis: No install request found for package: "sqlxml4", referred by package: "tools", install will be skipped as a result. Skipped: RepairForBackwardsCompatRedistAction Skipped: Action "RepairForBackwardsCompatRedistAction" was not run. Information reported during analysis: Action: "RepairForBackwardsCompatRedistAction" will be skipped due to the following condition: Condition "sql was successfully upgraded." returned false. Condition context: sql failed to upgrade and so the uninstall of the upgraded product will not occur. Error: Action "UninstallForMSDE2000Action" failed during execution. Error information reported during run: Action: "UninstallForMSDE2000Action" will be marked as failed due to the following condition: Condition "sql was successfully upgraded." returned false. Condition context: sql failed to upgrade and so the uninstall of the upgraded product will not occur. Installation of package: "patchMSDE2000" failed due to a precondition. Error: Action "UninstallForSQLAction" failed during execution. Error information reported during run: Action: "UninstallForSQLAction" will be marked as failed due to the following condition: Condition "sql was successfully upgraded." returned false. Condition context: sql failed to upgrade and so the uninstall of the upgraded product will not occur. Installation of package: "patchLibertySql" failed due to a precondition. Skipped: InstallASAction Skipped: Action "InstallASAction" was not run. Information reported during analysis: No install request found for package: "as", install will be skipped as a result. Skipped: InstallRSAction Skipped: Action "InstallRSAction" was not run. Information reported during analysis: No install request found for package: "rs", install will be skipped as a result. Skipped: UninstallForRS2000Action Skipped: Action "UninstallForRS2000Action" was not run. Information reported during analysis: Action: "UninstallForRS2000Action" will be skipped due to the following condition: Condition "Action: InstallRSAction was skipped." returned true. Running: ReportChainingResults at: 2005/11/19 14:44:27 Error: Action "ReportChainingResults" threw an exception during execution. One or more packages failed to install. Refer to logs for error details. : 1706 Error Code: 0x800706aa (1706) Windows Error Text: The endpoint format is invalid.
Source File Name: sqlchainingsqlchainingactions.cpp Compiler Timestamp: Thu Sep 1 22:23:05 2005 Function Name: sqls::ReportChainingResults::perform Source Line Number: 3097
Ive seen this asked all over but am yet to find a fix for my case.
I have 1 SharePoint 2007 server 1 SQL 2005 SP2 server with Reporting services running
Reporting services is configured and running all with ticks in SharePoint integration mode, the reporting services section shows up in Central Admin ok.
When I try to access reporting services I get the error :
http://reports.domain/reportserver
Report Server has encountered a SharePoint error. (rsSharePointError) Get Online Help
For more information about this error navigate to the report server on the local server machine, or enable remote errors Looking thru the logs I get the error :
w3wp!library!d!04/04/2008-13:54:20:: Call to GetItemTypeAction(/). w3wp!library!d!04/04/2008-13:54:20:: Call to ListParentsAction(/). w3wp!library!d!04/04/2008-13:54:20:: Call to ListChildrenAction(/, False). w3wp!library!d!04/04/2008-13:54:20:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.SharePointException: Report Server has encountered a SharePoint error., ; Info: Microsoft.ReportingServices.Diagnostics.Utilities.SharePointException: Report Server has encountered a SharePoint error. ---> System.NullReferenceException: Object reference not set to an instance of an object. at Microsoft.ReportingServices.SharePoint.Server.SharePointDBInterface.internalFindObjectsNonRecursive(String wssUrl, CatalogItemList& children) at Microsoft.ReportingServices.SharePoint.Server.SharePointDBInterface.FindObjectsNonRecursive(String wssUrl, CatalogItemList& childList, Security secMgr, IPathTranslator pathTranslator, Boolean appendMyReports) --- End of inner exception stack trace ---
I setup a new website called RS Web Site in IIS on the SQL box, I then set this in the Configure Report Server. I have made sure Annonymous access is off.
Does anyone know how on earth I can resolve this ..
Select Model, Kota as [Çıkan Anket] , (Select Count(*) From dbo.Main Where RuhsatSahibiModel = tt.Model) as [Verilen Adres] , (Select Count(RuhsatSahibiSahisID) From dbo.Main Where DurumKoduID in(1,2,3,4,5,6,9,12,13,14,15,16,17,20,21,22,23,24,25,26,27,28) and RuhsatSahibiModel = tt.Model) as [Donen Adres]
,
(Select Count(*) From dbo.Main Where DurumKoduID = 2 and RuhsatSahibiModel = tt.Model) as [Donen Anket] ,((Select cast(Count(*) as decimal(2,0)) From dbo.Main Where DurumKoduID = 2 and RuhsatSahibiModel = tt.Model ) / (Select top 1 (cast(Kota as decimal(2,0))) From dbo.Model Where Model = tt.Model))*100 as [Oran]
,
(Kota - (Select Count(*) From dbo.Main Where DurumKoduID = 2 and RuhsatSahibiModel = tt.Model)) as [Kalan Anket] , ((Select Count(*) From dbo.Main Where RuhsatSahibiModel = tt.Model)- (Select Count(RuhsatSahibiSahisID) From dbo.Main Where DurumKoduID in(1,2,3,4,5,6,9,12,13,14,15,16,17,20,21,22,23,24,25,26,27,28) and RuhsatSahibiModel = tt.Model)) as [Kalan Adres]
From
(SELECT Model, SUM(Kota) AS Kota FROM dbo.Model GROUP BY Model) as tt where tt.Model in('A3')
it's returning error message : "Divide by zero error encountered."
My exploit environment: VS.net 2003, SQL Server 2000 SP4, SQL Server CE 2.0 SP4
I write next codes: Private cn As New SqlCeConnection("data source=my documentsSQLCECF.sdf")
Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load Try If Not System.IO.File.Exists("my documentsSQLCECF.sdf") Then Dim en As New SqlCeEngine("data source=my documentsSQLCECF.sdf") en.CreateDatabase() 'create a blank database to subscribe Synch() End If Catch err As SqlCeException ShowErrors(err) Catch err As Exception MsgBox("There was an error:" & err.ToString()) End Try End Sub
Sub Synch() Try Dim rep As SqlCeReplication = New SqlCeReplication With rep .Publisher = "192.168.0.222" .PublisherDatabase = "CFLab" .PublisherLogin = "sa" .PublisherPassword = "sa" .Publication = "CFLab" .Subscriber = "SQLCENETCF" .SubscriberConnectionString = "Provider=Microsoft.SQLServer.OLEDB.CE.2.0;Data Source=My DocumentsSQLCECF.sdf" .InternetUrl = "http://192.168.0.222/SQLCE/sscesa20.dll" ' Create the Local SSCE Database subscription rep.AddSubscription(AddOption.CreateDatabase) rep.Synchronize() 'subscribe End With
Catch err As SqlCeException ShowErrors(err) Finally
End Try End Sub
Public Sub ShowErrors(ByRef e As SqlCeException)
Dim errorCollection As SqlCeErrorCollection = e.Errors Dim bld As System.Text.StringBuilder = New System.Text.StringBuilder Dim inner As Exception = e.InnerException
If Not inner Is Nothing Then MessageBox.Show(("Inner Exception:" & inner.ToString())) End If
For Each err As SqlCeError In errorCollection bld.Append("/n Error Code: " + err.HResult.ToString("X", System.Globalization.CultureInfo.CurrentCulture)) bld.Append("/n Message : " + err.Message) bld.Append("/n Minor Err.: " + err.NativeError.ToString()) bld.Append("/n Source : " + err.Source)
For Each numPar As Int32 In err.NumericErrorParameters
If 0 <> numPar Then bld.Append("/n Num. Par. : " + numPar.ToString()) End If
Next
For Each errPar As String In err.ErrorParameters
If String.Empty <> errPar Then bld.Append("/n Err. Par. : " + errPar) End If
Private Sub btnShow_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnShow.Click connect()
Dim query As String = "select * from FlightData" Dim dap As New SqlCeDataAdapter(query, cn) Dim dataset1 As New DataSet dap.Fill(dataset1, "FlightData")
Disconnect() End Sub Sub connect() Synch() Try cn.Open() Catch err As SqlCeException ShowErrors(err) End Try End Sub Sub Disconnect() Try cn.Close() Catch err As SqlCeException ShowErrors(err) End Try End Sub
Private Sub dgdResults_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles dgdResults.Click
End Sub End Class
I want to synchronize the data from a SQLCE SERVER 2000 When i run the code above, the errors show: Error Code:80040E17 MessageQL Server CE encountered problems in creating the SQL Sever CE database.
Error Code:80040E17 A data source with the specified name already exists.
I do not know what's going wrong..=( Who can help me??!!! HELP~~~~~~~~~ thanks..
