Timeout Error While Executing Oracle Function
Hi,
I have developed reports for Oracle database. I wanted to avoid use of OUT REF cursor hence am using function & calling it from reports.
The logic in SP/function is so complex that it takes 5 mins to execute n get the result. I see the results on the report server, But when I call that report from web application, I get System.Net.WebException - Time out error.
My questions:
1. What setting I make on report server to avoid timeout?
--Are these settings applied on report server restart?
2. Is there any setting needed for Datasource also?
TIA
Tanmaya
View Complete Forum Thread with Replies
Related Forum Messages:
Timeout Error While Executing Procedure
Hi, I have written a stored procedure that i then execute in a loop within a wrapper procedure: WHILE somecondition BEGIN EXEC dbo.PROC1 END If i run the procedure manually i can run it time after time with no error. However if i execute the procedure above i get a timeout error after about 2 or 3 loops. How can i avoid this? I have been reading everywhere and i dont seem to be able to find a solution...
View Replies !
Error Executing Non Query: Timeout Expired
I was having some errors from the webpage accessing the OLlinks table in the database. Error executing non query: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. StackTrace: 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.SqlDataReader.ConsumeMetaData() at System.Data.SqlClient.SqlDataReader.get_MetaData() 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.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) at System.Data.SqlClient.SqlCommand.ExecuteReader() at admin_admOLEditLinks.selectData(String strID) in e:wwwroothomeadminadmOLEditLinks.aspx.cs:line 101DateTime:5/23/2007 1:14:10 PMSource:http://www.myDomain.comiAdmin/admOLEditLinks.aspx?ID=3ErrorMessage:Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. I kept getting the above error so then I try to access the table directly inside of MS SQL Server Management Studio and then I recieved the following error: SQL Execution Error. Executed SQL statement: SELECT lnkID, linkFromID, linkToID FROM OLlinks Error Source: .Net SqlClient Data Provider Error Message: Timeout expired. The timeout period elapsed prior to completion of the opration or the server is not responding. Open any other table works fine except this table only. Any help is much appreciated.
View Replies !
SQL Express Timeout Error When Executing A View
I get the following error message: SQL Exectution error, Exectuted SQL statement: SELECT... Source: .Net SqlClient data provider Message: Timeout expired, timeout period elapsed prior to completion of the operation... The view is operating on a table of ~250,000 records. The timeout occurs after 45 seconds, and none of the changes I make to the various timeout settings in the server or database seem to affect this. When I execute the same sql statement in a query window it does complete, requiring about 7 minutes to execute. How can I configure the view not to timeout when executing this query? - Jim
View Replies !
Timeout Error When Executing SQL Command From The Script Task
The SQL query takes about 4 minutes to execute in SQL Management Studio. But when I run it from the Script Task using the OleDBCommand, I got the timeout error in 40 seconds. The timeout setting on the SSIS DB connection is 0. I do not see how to set the timeout for an SSIS task. Any thoughts on this problem? TIA.
View Replies !
Strange Timeout Problem When Executing Stored Proc
We have a stored procedure that will return at most about 600 records. In almost all cases it works fine, but in a few odd cases the command times out when used from a webform. We changed the CommandTimeout property to 120 seconds... no difference. If we run a query that times out in Query Analyzer, it runs in under 3 seconds (on the SQL Server machine). We also did a lot of profiling, and for any page that runs fine, the query takes about the same time when called from a webform and run in the Query Analyzer. We ran our tests on the pre-production environment with absolutely no one else on the machines. We also created a test page that just fills a DataSet. Straightforward... get connection object, create command, set params, create data adapter, fill dataset. It suffers the same problem. The web server and SQL server are two separate machines. Oh, and before I forget... This is SQL 2000. It used to run SQL 7, and all the queries there were (slightly) slower, but none timed out, not even the ones that do now. Maybe the first question should be: How can it be that a query that runs fine in Query Analyzer times out from a webform?
View Replies !
Error : Timeout Expired. The Timeout Period Elapsed Prior To Completion Of The Operation Or The Server Is Not Responding.
Hi, I am running a stored procedure that collects some records from two tables do some calculations with those records and insert those calculation result in a temp. table. I am calling this stored procedure in my aspx page and then later select all the records from temp table and show it in a table. When I run this application on browser it give me Timeout expired error but whn I execute the stored procedure it runs properly but takes around 3:10 mins to execute in query analyzer. I did some google work and based on that I specified CommandTimeout = 300 for SP and Connection timeout=400 in web.config. But still it didnt worked. Sometimes it runs properly but sometimes its not. Where I am doing mistake? and Wht should i do to resolve this? Plz. help. Thanks in adv. Regards, Yogita
View Replies !
Error : Timeout Expired. The Timeout Period Elapsed...
Hi,I get this error from our web application every once in a while. " Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding". I email myself when an error occurs, and once every 2-3 days I get this timeout error emails, like 5-10 emails in a span of few minutes. Then it goes away. I have set the command timeout for 60 secs. It doesn't happen from the same stored procedure, actually I have seen it timeout from really simple 1 or 2 line stored procedures, which shouldn't normally take 1 sec. Its like sql server just shuts down for few minutes. We have some backups and maintenance jobs scheduled, but they run only after midnight. I have checked the application event viewer, there are no warnings or error messages for MSSQLSERVER. Can any one tell me how to check whats going on during that short timespan when timeout error occurs, and what causes it? I don't want to run sql profiler continuously for 2-3 days, I am afraid it will slow down the server more. Thanks.
View Replies !
Executing An Oracle Stored Procedure From SSIS
Hello, Is there an oracle provider out there that will let me invoke a parameterless stored procedure that is in a package in my Oracle source? Better could that stored proc receive a prameter? Still better, could I use a stored proc in a OLEDB source component and get the resutls from its only out variable (ref cursor) into my SSIS dataflow? I haven't been able to get any of these basic functionalities working with either the Oracle OLEDB or the Microsoft OLEDB for Oracle provider... If not, are there any plans to enahnce the MS provider to handle that? A more tricky question : Why does the ReportingService data processing extension for Oracle sources allow such things and not the .NET provider in SSIS? Thanks
View Replies !
Problem Executing A Oracle Procedure Using Execute Sql Task
Hi All, I am trying to execute a Oracle Procedure through Execute Sql Task but it keeps throwing back an error ORA:00900. Is it possible to execute the procedure from this object? Do I need to use the script task to execute this. If yes then how? Any help would be appreciated. Thanks in advance. Amol
View Replies !
Executing CLR Function Within SSIS
Hi, I have a bit of a strange problem. I've created a CLR function in VS 2005, C#, created assembly in database (permission_set = safe) and created a function in my database to call the external Assembly.Class.Function. That is all working fine, and as a dbo I can execute the function directly, or by using it in a stored proc and calling the sp and it all works great if done from within Microsoft SQL Management Studio. However, if I try calling the same sp (which in turn calls CLR function) in SSIS (data flow task) then it simly does not work. There are no errors, but the function simply does not work. Does anyone have any ideas as to what is going wrong? Many thanks, NR
View Replies !
Function Causes A Timeout
I have a function which is causing a time out it is only being used on 1700 records and the problem seems to happen in the afternoon The client gets the error on a live system and so do I on the dev system ALTER FUNCTION [8977].[isClosed] (@Iref nvarchar(30),@clid int)RETURNS BITAS/* if the event is closed return true */BEGINRETURN (SELECT closedFROM dbo.tblOCompEventsWHERE (ClientID = @clid) AND (IRef = @Iref)GROUP BY closedHAVING (closed = 1))END I am using in like thisAND ([8977].isClosed(tblOCompEvents.IRef, tblOCompEvents.ClientID) IS NULL) I have taken the IRef Argument out still times outI have changed it from IS NULL to = 0 and to = 1, all still cause a time outany ideas please?
View Replies !
Executing Oracle Stored Procedure With Output Parameters Using ADO.NET Connection
I am a bit confused by an issue that I am having with executing an Oracle stored procedure (with an output parameter) using an ADO.NET connection object. I am able to get this working using an OLEDB connection, but I have no idea why the ADO.NET connection doesn't work. (Bug, by design, or my ignorance?) Actually, I can even get this to work if I use the .NET Providers for OLE DBMicrosoft OLE DB Provider for ORACLE if we set the connectionType to ADO.NET. This is the error that I am receiving: [Execute SQL Task] Error: Executing the query "pkg_utility_read.test_out_var " failed with the following error: "The OracleParameterCollection only accepts non-null OracleParameter type objects, not SqlParameter objects.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly. It is also worth mentioning that the ORACLE stored procedure has an out parameter with a NUMBER datatype which I think maps to the ADO.NET Int32 datatype. I guess OLE DB datatypes are more closely mapped to ORACLE datatypes. In OLE DB you can set the parameter to double and the ORACLE stored procedure to NUMBER and it works. Any help on this would be most appriciated.
View Replies !
Executing A Function In Report Services
Hi all I have a function that I'm trying to make a report with SQL server report services. My problem is everytime I add a table I addd the function and I get the table with a red arrow pointing down, when I try to execute int sql server intelligence development studio it gives me an error message. can anyone help pleaes
View Replies !
Oracle Publication Error:The Permissions Associated With The Administrator Login For Oracle Publisher 'test1' Are Not Sufficient
Hi, I am trying to make an oracle publiching from sql server 2005 enterprise final release, i installed the oracle client 10.2 (10g) on the same server where sql server already installed, i made different connection to oracle database instance and it was ok. from sql server : right click on publication -New oracle publication-Next-Add Oracle Publisher-Add button-Add Oracle Publisher-i entered server insttance test1 and their users and passwords--connect ---> the oracle publisher is displayed in the list of publisher but when press ok i got the following error : TITLE: Distributor Properties ------------------------------ An error occurred applying the changes to the Distributor. For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.1399.06&EvtSrc=Microsoft.SqlServer.Management.UI.DistributorPropertiesErrorSR&EvtID=ErrorApplyingDistributor&LinkId=20476 ------------------------------ ADDITIONAL INFORMATION: SQL Server could not enable 'test1' as a Publisher. (Microsoft.SqlServer.ConnectionInfo) ------------------------------ An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo) ------------------------------ The permissions associated with the administrator login for Oracle publisher 'test1' are not sufficient. Changed database context to 'master'. (Microsoft SQL Server, Error: 21684) For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.1399&EvtSrc=MSSQLServer&EvtID=21684&LinkId=20476 ------------------------------ BUTTONS: OK ------------------------------ Any idea about this error ? Thanks Tarek Ghazali SQL Server MVP.
View Replies !
Oracle NVL Function
Hi, I want to know if there is a function in SQL Server that do the same thing than the Oracle function NVL() In Oracle we can do the following thing : select nvl(last_name,first_name) from table_test; This have the effect that if the last_name field is NULL, it will display the first_name Is there a function like this in SQL 7 Thank Martin
View Replies !
Oracle Translate Function Equivalent In SQL Server
Hi I want to know the equivalent of the Oracle translate function in SQL Server. eg : select translate('entertain', 'et', 'ab') from dual. I tried the SQL Server Replace function , but it replaces only one character or a sequence of character and not each occurrence of each of the specified characters given in the second argument i.e 'et'. Please let me know if there is some other equivalent function in SQL Server thanks.
View Replies !
How To Use The OLEDB Command To Call A Oracle Function?
HI, I want to use the OLEDB command to call a oracle function, but i havnt found any materials about how to do that, my oracle function is as below: CREATE OR REPLACE function GET_ZONEID_FROM_SYFZ(ycz varchar2,xc varchar2,strat_id varchar2) return varchar2 IS zone_id_result varchar2(10) ; begin PKG_DM_DQ.GET_ZONEID_FROM_SYFZ(ycz,xc,strat_id,zone_id_result); return zone_id_result; end; In OLEDB command transformation component, i fill the sql command with "select GET_ZONEID_FROM_SYFZ(?,?,?) from dual", but i dont have it worked. The error message is :provider can not derive parameter information and setparameterinfo has not been called. Who have any idea about how to make it work? Thanks ~~
View Replies !
Oracle Translate Function Equivalent In SQL Server
Hi I want to know the equivalent of the Oracle translate function in SQL Server. eg : select translate('entertain', 'et', 'ab') from dual. I tried the SQL Server Replace function , but it replaces only one character or a sequence of character and not each occurrence of each of the specified characters given in the second argument i.e 'et'. Please let me know if there is some other equivalent function in SQL Server thanks.
View Replies !
Error = -2147467259 (80004005) Error String: Timeout Expired
Hi everybody, I do custom log shipping over network like step 1 backup log to C:.. step 2 zip log file c:... zip step 3 copy zip to \sm01 estorelogs... step 4 unzip file step 5 restore log with stand by Few times a month it fails with Error = -2147467259 (80004005) Error string: Timeout expired Error source: Microsoft OLE DB Provider for SQL Server Help file: Help context: 0 Error Detail Records: Error: -2147467259 (80004005); Provider Error: 0 (0) Error string: Timeout expired Error source: Microsoft OLE DB Provider for SQL Server Any idea ,what might cause it ? Thank you Alex
View Replies !
Timeout Expired Error - SQL Server 2005 Error After Exactly 1 Hour
We have several large government web sites that we help look after. We recently migrated one of them from SQL Server 2000 to 2005 and are having a problem with our nightly email job in that if it runs for more than an hour then after exactly 1 hour the email job gets a "Timeout expired" message back from SQL Server. Our batch jobs do run on a different server and connect remotely to our SQL Server DB. I did change the connections - remote query timeout and increased it 10 fold, but this didn't make any difference. Is there any other parameter that may be causing the Timeout expired error after exactly 1 hour? Thanks !
View Replies !
[298] SQLServer Error: 258, TCP Provider: Timeout Error [258]. [SQLSTATE 08001]
I've received this error twice over 2 days in the SQL Agent error log during off-hours from a server which has not had any changes to it in the last few months (once at 3:32AM and the next day at 3:46AM. I've been able to tie it to log-shipping backup jobs (all of which run under the SQL Service domain account) which run every minute. It seems to be only momentary, as the next attempt a minute later is successful. I get the same set of messages for each database for the same time which look like this: Date 07.03.2008 3:31:51 AM Log SQL Agent (Current - 10.03.2008 6:15:00 PM) Message [298] SQLServer Error: 258, TCP Provider: Timeout error [258]. [SQLSTATE 08001] Date 07.03.2008 3:31:52 AM Log SQL Agent (Current - 10.03.2008 6:15:00 PM) Message [165] ODBC Error: 0, Login timeout expired [SQLSTATE HYT00] Date 07.03.2008 3:31:52 AM Log SQL Agent (Current - 10.03.2008 6:15:00 PM) Message [298] SQLServer Error: 258, Unable to complete login process due to delay in login response [SQLSTATE 08001] Date 07.03.2008 3:31:52 AM Log SQL Agent (Current - 10.03.2008 6:15:00 PM) Message [382] Logon to server '(local)' failed (SubSystemStepHistoryLogger) I can't find any documentation on these errors on the web or MSDN site. Can I chalk this up to possibly "winking" connection to our domain controller? We've never had these messages before, and our LAN department swears that there have been no upgrades to the network or domain controller servers recently.
View Replies !
Error H4000 Error While Executing The Query ???????????
Hi all my problem is as follows : when i try to configure an ODBC DataAdapter using the configuration wizard i use the query builder to select some fields from multiple tables , the displayed info depends in a user input , when i define the input parameter by writing(= ?) in the criteria column of the input field and continues , it displays an error Error H4000 Error while executing the query , Error near ')' near character (214 for example). so please if any one knows the solution to this error reply soon Thanks a lot Mina Samy
View Replies !
An Error Occurred While Executing Batch. Error Mes
I am getting this error An error occurred while executing batch. Error message is: The directory name is invalid." in sql management studio. i found that if i switch to results to text i don't get the error but with results to grid I get it no matter what i query in any database on the server.
View Replies !
Executing DTS - DSN Error...
Perhaps this has already been answered. If so, I apologize. I'm anewbie at this stuff. I have a DTS package to import some VisualFoxpro data. Yes, I said Visual Foxpro. :) The DTS package worksbeautifully when I rightclick on the package and choose "execute." Andit works beautifully when I run dtsrun.... at the DOS prompt. But itdoesn't work when I try to execute it with code in Query Analyzer.I've tried exec master..xp_cmdshell 'dtsrun ...' And I've triedscheduling the package as a Job, disabling the Job and then usingmsdb..sp_start_job to run it. Neither of those work.I get a "DSN not found and no default driver specified."My DSN stuff looks OK to me, but perhaps some of that is wrong. Whatdoes the DSN have to look like in order for the code in Query Analyzerto find it? If the DSN is screwed up, why would it work OK whenexecuted from some places, but not in others? What am I missing?Any help would be much appreciated. :) thanks...-emily
View Replies !
Error 266 After Executing SP
I am facing this error when using a SP called by a DTS package (using ADO connection). The SP gets three parameter and looks like the following (just major part of it): SET @STR = 'SET ROWCOUNT 10000' + ' WHILE 1 = 1 ' + 'BEGIN' + ' BEGIN TRAN' SET @STR = @STR + ' DELETE FROM ' + @TableToBeCleaned + ' WHERE ' + @SELECTEDCOLUMN + ' < DATEADD (m,' + ' -' + @KeepMonthsInDatabase + ', + GETDATE())' SET @STR = @STR + 'IF @@ROWCOUNT = 0 ' + 'BREAK ' + 'COMMIT ' + 'END ' + 'SET ROWCOUNT 0' EXEC (@str) Following error appears: Server: Msg 266, Level 16, State 2, Line 1 Transaction count after EXECUTE indicates that a COMMIT or ROLLBACK TRANSACTION statement is missing. Previous count = 4, current count = 5. Server: Msg 266, Level 16, State 2, Procedure p_DBCleanerDeleteRows, Line 56 Transaction count after EXECUTE indicates that a COMMIT or ROLLBACK TRANSACTION statement is missing. Previous count = 4, current count = 5. I use the SET ROWCOUNT to execute the delete in batches. When checking with SELECT @@TRANCOUNT it returns me 5. Somehow it is clear to me that @@TRANCOUNT exited the SP with another value than when entering it but there is commit in the dynamic SQL statement and I do not know what is wrong. Is it neccessary to indicate BEGIN TRAN and COMMIT in the statement at all or can I ommit it? Thanks mipo
View Replies !
Oracle Error &"ORA-12154&" From An Application Which Never Uses Oracle
My application which ran perfectly well yesterday suddenly stopped working in this morning with following error message. I didn't change anything, at least I believe. Interesting thing is that I don't use any Oracle connection but connects to MS SQL Server 2005 Express version locally. Error messages are different according to the connection string though I don't think it makes difference: ConnectionString = <add key="Databasehandtool1" value="Data Source=.SQLEXPRESS;Database=handtool;SSPI=true" />ErrorMessage from VS2008 ="Unable to get records. Object reference not set to an instance of an object." ConnectionString = <add key="Databasehandtool1" value="Data Source=.SQLEXPRESS;Database=handtool;User Id=handtool_DB;Password=mypassword" />ErrorMessage from VS2008 = "Unable to get records. Unable to connect to database. ORA-12154: TNS:could not resolve the connect identifier specified." By the way, the application was generated from IronSpeed 5.1 Enterprise. My development environment is : VS2008, SQL2005 EXPRESS, Windows XP SP2, ASP.NET 2.0 We have actually an Oracle server in the network though. My gut feeling is that something might have changed in my network server during the night but how come it can possibly affect my application running on my local PC. I checked the connection of local SQL Express Server from SQL Server Management Studio and it connected well with UserID=handtoo_DB and showed all tables and stored procedures required for the application. So there is no problem in SQL Server database side. I would welcome and appreciate any input. fudata
View Replies !
Error In Executing Jobs
Hi and thanks in advance for any assistance... The problem we're trying to execute a number of scheduled tasks in a specific sequence, which involves a connection between a local SQL Server and an AS/400 server. Basically, these tasks perform SQL Server table truncation, data transformation from the AS/400 into these SQL Server tables to re-populate them. This is pumped into an Excell spreadsheet as a final output and should be an automated process, but right now it is being manually run each week. When doing scheduled test runs, we get an error referring to some sort of link error. Any idea what we should be looking at?
View Replies !
Error Executing Assemblie
hellow i execute assemblie in sql server, assemblie opens up file and writes some information, when i run that esemblie i get the follwing message An error occured: Request for the permission of type 'System.Security.Permissions.FileIOPermission, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' failed. thanks for any ideas
View Replies !
Error Encountered While Executing A UDF
Hi, I get the following error while trying to execute a UDF. Msg 6522, Level 16, State 1, Line 1 A .NET Framework error occurred during execution of user defined routine or aggregate 'test': System.NullReferenceException: Object reference not set to an instance of an object. System.NullReferenceException: at SalesCentral_Database.UserDefinedFunctions.udfTest() My function is defined as follows: Imports System Imports System.Data Imports System.Data.SqlClient Imports System.Data.SqlTypes Imports Microsoft.SqlServer.Server Partial Public Class UserDefinedFunctions <Microsoft.SqlServer.Server.SqlFunction(DataAccess:=DataAccessKind.Read)> _ Public Shared Function udfTest() As SqlString SqlContext.Pipe.Send(System.DateTime.Now().ToString()) Dim conn As New SqlConnection("context connection=true") conn.Open() Dim cmd As New SqlCommand("SELECT MAX(ACCTPERIOD) FROM TBL_OPPORTUNITY_HIS", conn) Return New SqlString(cmd.ExecuteScalar().ToString()) End Function End Class SQL Server CREATE ASSEMBLY SalesCentral_Database from '\isew5l6c ranfSFS_SalesSalesCentral_Database.dll' WITH PERMISSION_SET = SAFE CREATE FUNCTION test() RETURNS NVARCHAR(10) AS EXTERNAL NAME [SalesCentral_Database].[SalesCentral_Database.UserDefinedFunctions].[udfTest] SELECT dbo.test() - Here I get the error mentioned above. Can anyone please tell me what am I missing. Thanks.
View Replies !
Error Executing Packaga From Job
Hello, I finally could upload the package, and from the management studio interface I ran the package and it worked perfectly. When I created a job, with one step only to execute that package, the job fails. When I go to history it doesnt give me any details of what failed on the package or in the job Date 24/01/2007 12:30:28 Log Job History (Carga datos ACH) Step ID 1 Server ATLANTESQL2005 Job Name Carga datos ACH Step Name Carga de datos de ach Duration 00:00:02 Sql Severity 0 Sql Message ID 0 Operator Emailed Operator Net sent Operator Paged Retries Attempted 0 Message Executed as user: ATLANTESYSTEM. The package execution failed. The step failed. Maybe is the user that it tried to execute the package as? How can I change it?
View Replies !
Package Executing Error
I wrote package using Integration Services and tried execute it on Visual Studio 2003 (Visual Basic). Package was loaded, but execute method has failed without any error messages. When I tried to run it on Visual Studio 2005, execution was successful. Codes: Dim App As DTSLib.IDTSApplication90 = New DTSLib.Application Dim p As DTSLib.IDTSPackage90 = App.LoadPackage("d: empPackage.dtsx", True, Nothing) p.Execute() What can be the reason of the trouble? Thanks, Alexander
View Replies !
Error When Executing TransferDatabaseTask From
This is the error I get if the login "reports" does not exist on the destination server Error: The Execute method on the task returned error code 0x80131500 (ERROR : errorCode=-1073548784 description=Executing the query "EXEC dbo.sp_grantdbaccess @loginame = N'reports', @name_in_db = N'reports' " failed with the following error: "'reports' is not a valid login or you do not have permission.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly. helpFile= helpContext=0 idofInterfaceWithError= {8BDFE893-E9D8-4D23-9739-DA807BCDC2AC}). The Execute method must succeed, and indicate the result using an "out" parameter. This is the error I get if the login "reports" does exist on the destination server Error: The Execute method on the task returned error code 0x80131500 (ERROR : errorCode=-1073548784 description=Executing the query "EXEC dbo.sp_grantdbaccess @loginame = N'reports', @name_in_db = N'reports' " failed with the following error: "User, group, or role 'reports' already exists in the current database.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly. helpFile= helpContext=0 idofInterfaceWithError={8BDFE893-E9D8-4D23-9739-DA807BCDC2AC}). The Execute method must succeed, and indicate the result using an "out" parameter. What am I doing wrong ?
View Replies !
Error In Executing Package
Hi All, I created a Package that calls Three other Packages through the Execute package task. I saved The main package and the sub-packages in Dontsavesensitive mode and Referred to the config file. I checked the Package thru VSS and When iam running thru the Bat file iam getting the following error Description: Error 0x80070002 while loading package file "C:Documents and SettingsUSERNAMEMy DocumentsVisual Studio 2005ProjectsImportFILEImportFILEPACKAGE.dtsx". The system cannot find the file specified. Iam not sure why its asking for this path in the production server. This is the initial path where i saved the package in BIDS environment. Please help me.Help is greatly appreciated. Thanks, SVGP .
View Replies !
Error Executing Xp_cmdshell
I'm trying execute DTSX-package Code Block exec master..xp_cmdshell '"C:Program Files (x86)Microsoft SQL Server90DTSBinndtexec.exe" /FILE ...' But have got error Code Block 'C:Program' is not recognized as an internal or external command, for some reason it doesn't work! Or xp_cmdshell doesn't work with long filenames?
View Replies !
Error When Executing Report
Hello, Today we succesfully integrated Report Services with Sharepoint services.After that I was trying to implement the reports we made in Report Services into the Sharepoint site.The first report was ok, everything went well, no errors and the report was succesfully executed.Then the second report, it is a bit a bigger and more advanced report.It also has to be executed at an other server.I am going to explain how the server setup is.We have 2 servers, a x32 and a x64 server.The x64 server is the "Live" server, and the x32 is our "Test" server.On the x32 server we have MS SQL Server 9.0.3200 (SP2), it is the same as on the x64 server.When i try to execute the report on the x32 server, I got an error.The error I get from reporting server is: An internal error occurred on the report server. See the error log for more details.So I checked the error log, and then I got the following message: EventType sql90exception, P1 w3wp.exe, P2 6.0.3790.3959, P3 45d6968e, P4 reportingservicesnativeclient.ni.dll, P5 2005.90.3042.0, P6 45cd6edb, P7 0, P8 00005283, P9 00000000, P10 NIL.For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp. After I had found the error, I had searched on Google what the message means. I found some topics on other forums that said "Install SP2". But that was not an option since we are on SP2. Some additional information: Just tried to run the first report on the x32 server, and it worked. So the first report runs on the x32 as the x64 server. Can someone tell me what to do? Thanks, Rens
View Replies !
Error Executing DB2OLEDB.exe
I am trying to install the DB2 driver from the SQl Server Feature Pack and getting an error message: The procedure entry point DeleteObjec! could not be located in the dynamic link library GDI32.dll. Please advise.
View Replies !
Error Executing Procedure
when i try to run a procedure i've been working on, i get the following Error: Server: Msg 8144, Level 16, State 2, Line 0 Procedure or function has too many arguments specified. execution code: exec search_orders_1 @dwelltype=1 stored procedure: SET QUOTED_IDENTIFIER ON GO SET ANSI_NULLS ON GO ALTER PROCEDURE search_orders_1 @lowageint=null, @highageint=null, @highwealthint=null, @lowwealthint=null, @highpurpriceint=null, @lowpurpriceint=null, @lowmtgamtint=null, @highmtgamtint=null, @lowincomenvarchar(4000)=null, @highincomenvarchar(4000)=null, @marriedstatnvarchar(4000)=null, @lowyearbuildnvarchar(4000)=null, @highyearbuildnvarchar(4000)=null, @mtgpresstatnvarchar(4000)=null, @lenderpresstatnvarchar(4000)=null, @ratetsnvarchar(4000)=null, @loantsnvarchar(4000)=null, @childstatnvarchar(4000)=null, @homeownerstatnvarchar(4000)=null, @lowpurdatenvarchar(4000)=null, @highpurdatenvarchar(4000)=null, @addresstype varchar(3)=null, @SPSirvarchar(3)=null, @debttypevarchar(3)=null, @dwelltypevarchar(3)=null, @zipselectnvarchar(4000)=null, @acselectnvarchar(4000)=null, @stselectnvarchar(4000)=null, @cityselectnvarchar(4000)=null, @counselectnvarchar(4000)=null,-- as @debug bit = 0 AS DECLARE @sql nvarchar(4000), @paramlist nvarchar(4000) SELECT @sql ='SELECT o.state_abbrv, count(o.state_abbrv) as kount FROM dbo.mortgage o WHERE 1 = 1' IF @lowage<>0 and @lowage is not null SELECT @sql = @sql + ' AND o.per1_age >= @xlowage' IF @highage<>0 and @highage IS NOT null SELECT @sql = @sql + ' AND o.per1_age <= @xhighage' IF @lowincome<>'DF' and @lowincome IS NOT NULL SELECT @sql = @sql + ' AND o.est_inc >= @xlowincome' IF @highincome<>'DF' and @highincome IS NOT NULL SELECT @sql = @sql + ' AND o.est_inc <= @xhighincome' IF @highwealth<>0 and @highwealth IS NOT NULL SELECT @sql = @sql + ' AND o.wealth_rating <= @xhighwealth' IF @lowwealth<>0 and @lowwealth IS NOT NULL SELECT @sql = @sql + ' AND o.wealth_rating >= @xlowwealth' IF @highpurprice<>0 and @highpurprice IS NOT NULL SELECT @sql = @sql + ' AND o.hm_purprice <= @xhighpurprice' IF @lowpurprice<>0 and @lowpurprice IS NOT NULL SELECT @sql = @sql + ' AND o.hm_purprice >= @xlowpurprice' IF @lowyearbuild<>'DF' and @lowyearbuild IS NOT NULL SELECT @sql = @sql + ' AND o.hm_year_build >= @xlowyearbuild' IF @highyearbuild<>'DF' and @highyearbuild IS NOT NULL SELECT @sql = @sql + ' AND o.hm_year_build <= @xhighyearbuild' IF @lowmtgamt<>0 and @lowmtgamt IS NOT NULL SELECT @sql = @sql + ' AND o.oo_mtg_amnt >= @xlowmtgamt' IF @highmtgamt<>0 and @highmtgamt IS NOT NULL SELECT @sql = @sql + ' AND o.oo_mtg_amnt <= @xhighmtgamt' IF @lowpurdate<>'DF' and @lowpurdate IS NOT NULL SELECT @sql = @sql + ' AND o.hm_purdate >= @xlowpurdate' IF @highpurdate<>'DF' and @highpurdate IS NOT NULL SELECT @sql = @sql + ' AND o.hm_purdate <= @xhighpurdate' IF @marriedstat in ('M','S') SELECT @sql = @sql + ' AND o.per1_ms = @xmarriedstat' IF @ratets in ('V','F') SELECT @sql = @sql + ' AND o.oo_mtg_rate_t = @xratets' IF @homeownerstat in ('H','R') SELECT @sql = @sql + ' AND o.homeowner = @xhomeownerstat' IF @childstat in ('Y','N') SELECT @sql = @sql + ' AND o.child_pres = @xchildstat' IF @lenderpresstat ='Y' SELECT @sql = @sql + ' AND o.oo_mtg_lender_name<>+ '' ''' IF @lenderpresstat ='N' SELECT @sql = @sql + ' AND o.oo_mtg_lender_name=+ '' ''' IF @mtgpresstat='Y' SELECT @sql = @sql + ' AND o.oo_mtg_amnt>0' IF @mtgpresstat='N' SELECT @sql = @sql + ' AND o.oo_mtg_amnt=0' IF @loants<>'DF' and @loants IS NOT NULL SELECT @sql = @sql + ' and o.oo_mtg_loan_t in ( ''' + REPLACE( @loants, N',', N''',''' ) + N''' )' if @dwelltype='1' SELECT @sql = @sql + ' and o.addr_unit_desnum='' ''' if @dwelltype='2' SELECT @sql = @sql + ' and o.addr_unit_desnum<>'' ''' if @acselect <> 'DF' or @stselect <> 'DF' or @cityselect <> 'DF' or @counselect <> 'DF' or @zipselect <> 'DF' SELECT @sql = @sql + ' and (1=2' IF @acselect<>'DF' and @acselect IS NOT NULL SELECT @sql = @sql + ' OR o.areacode in ( ''' + REPLACE( @acselect, N',', N''',''' ) + N''' )' IF @stselect<>'DF' and @stselect IS NOT NULL SELECT @sql = @sql + ' OR o.state_abbrv in ( ''' + REPLACE( @stselect, N',', N''',''' ) + N''' )' IF @cityselect<>'DF' and @cityselect IS NOT NULL SELECT @sql = @sql + ' OR o.citystate in ( ''' + REPLACE( @cityselect, N',', N''',''' ) + N''' )' IF @counselect<>'DF' and @counselect IS NOT NULL SELECT @sql = @sql + ' OR o.countystate in ( ''' + REPLACE( @counselect, N',', N''',''' ) + N''' )' IF @zipselect<>'DF' and @zipselect IS NOT NULL SELECT @sql = @sql + ' OR o.zip in ( ''' + REPLACE( @zipselect, N',', N''',''' ) + N''' )' if @acselect <> 'DF' or @stselect <> 'DF' or @cityselect <> 'DF' or @counselect <> 'DF' or @zipselect <> 'DF' SELECT @sql = @sql + ')' SELECT @sql = @sql + ' group by o.state_abbrv ORDER BY o.state_abbrv ' IF @debug = 1 PRINT @sql SELECT @paramlist = '@xlowageint, @xhighageint, @xlowincomenvarchar(4000), @xhighincomenvarchar(4000), @xmarriedstatnvarchar(4000), @xhighwealthint, @xlowwealthint, @xhighpurpriceint, @xlowpurpriceint, @xlowyearbuildnvarchar(4000), @xhighyearbuildnvarchar(4000), @xlowmtgamtint, @xhighmtgamtint, @xmtgpresstatnvarchar(4000), @xlenderpresstatnvarchar(4000), @xratetsnvarchar(4000), @xloantsnvarchar(4000), @xchildstatnvarchar(4000), @xhomeownerstatnvarchar(4000), @xlowpurdatenvarchar(4000), @xhighpurdatenvarchar(4000), @xzipselectnvarchar(4000), @xacselectnvarchar(4000), @xstselectnvarchar(4000), @xcityselectnvarchar(4000), @xcounselectnvarchar(4000)' EXEC sp_executesql @sql, @paramlist, @lowage, @highage, @lowincome, @highincome, @marriedstat, @highwealth, @lowwealth, @highpurprice, @lowpurprice, @lowyearbuild, @highyearbuild, @lowmtgamt, @highmtgamt, @mtgpresstat, @lenderpresstat, @ratets, @loants, @childstat, @homeownerstat, @lowpurdate, @highpurdate, @addresstype, @SPSir, @DebtType, @DwellType, @zipselect, @acselect, @stselect, @cityselect, @counselect GO SET QUOTED_IDENTIFIER OFF GO SET ANSI_NULLS ON GO could someone help me figure out what's up? someone told me you can have 1,024 parameters for a stored procedure.... what am i missing? do i have to many IF clauses?
View Replies !
Error In Executing Asp+mssql
Hello, I hope this forum is suitable for posting my question. I have a site in asp and vb with an access database. It's work just fine. I want to convert my database from access to mssql express. So I convert it with Microsoft SQL Server Migration Assistant for Access. I also install mssql server on my computer, so I can test my site at home. But now, I have trouble, I've received many errors like: [Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near '#'. (this appear when I try to insert date and time in database, witch in access database I have no problem) ODBC driver does not support the requested properties (this appears when I make a selection in database, where I use inner join). And many more ... Do I have to rewrite the code to all my files? It's so different working with MSSQL comparing with Access database? From what I read, I understand that after converting the database from Access to MSSQL, I must change only the connection string and the site have no problem. But it seems it's not so easy. I'm pretty disappointed. Can you give me an advice? Or some links where I can read something that can help me. Thanks.
View Replies !
Timeout Error
Hi All,I’m connecting to a database through a connection string <add name="ConStr" connectionString="Data Source=KXXX1-SQL;Initial Catalog=ROOTDATA.MDF;Integrated Security=SSPI;connection timeout=0" providerName="System.Data.SqlClient"/> but I’m getting the following error Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding I know this was handled previously in this forum and the remark was to set CommandTimeout = 0 How do I do that?
View Replies !
TimeOut Error
User r complaining tht they sometimes get SQLServer Timeout error. on investigating i found tht suppose one user is updating the database which is taking some time and at the same time if another user tries to retrieve some data from the database he gets a timeout error after some time........... However if the updateor insert action get over very quickly then the other user is able to retrieve the data ........ Is it bcoz tht the update statements r locking the datatables during the opperation and so the other user has to wait.. if tht is the case then wat is solution tht the other can retrieve the data without much waiting while one user is updating ........
View Replies !
Timeout Error
We have an ASP script that connects to our SQL 2000 server. The database we have currently contains around 3 million records which have 9 fields. When we ran some of our scripts, we get a timeout error. Our asp scripts have the scripttimeout property set to 3600 seconds. How come we still have a timeout error? Is there something we should configure in the SQL server to prevent the timeout error? Thanks in advance. Dido Jove
View Replies !
Please Help Me - Timeout Error
Hi, I have a view which it self is based on a number of views (using joins).... When I try to return all records I get a Timeout message...Is there any solution? Is there "something/anything" that I can do to somehow increase the Time-out or the setting of some parameter so taht I do not get this message and get the results? I'll appreciate your help.
View Replies !
|
TRACKER
