Qdabra Database Accelerator

Re: Infopath submits succesful but SQL does not receive any data

Ruben337 — Tue, 08 Oct 2013 21:31:38 GMT

Hey, Thanks for all the help!!! I switched the domain trust level but now I have received a new error! This form cannot be opened because it requires the domain permission level and it currently has restricted permission. To fix this problem, open the form from the location it was published to." And it gives you two options, "OK" and "Show Details>>" When I open the form on the location, It generates another error reffering to the domain problem and the details say Acces Denied. Do you know how to get passed this? Thanks!

Re: Infopath submits succesful but SQL does not receive any data

ErnestoM — Tue, 08 Oct 2013 20:13:58 GMT

Hi-

Thanks for attaching the form. I think the issue is that the form is set to Full Trust. I don't see any code in the form, so I'm not sure why it's set to Full Trust.

You can change the setting in Form options (to Domain) and this should allow the submit data connection to work correctly.

Hope this helps!

Re: Infopath submits succesful but SQL does not receive any data

Ruben337 — Tue, 08 Oct 2013 19:28:55 GMT

Alright! I used the example to create the data connection, here is the form.

Re: Infopath submits succesful but SQL does not receive any data

ErnestoM — Tue, 08 Oct 2013 19:19:11 GMT

Ok, so that's the first thing to investigate.

The form should have a data connection that submits to the DBXL web service. That data connection is either not executing or failing, since the document is not being submitted to DBXL and not showing up in the Documents table of DAT.

Do you want to attach your form here (via the Options tab)?

Thanks.

Re: Infopath submits succesful but SQL does not receive any data

Ruben337 — Tue, 08 Oct 2013 19:14:39 GMT

No it doesnt increase only the form version increase.

Re: Infopath submits succesful but SQL does not receive any data

ErnestoM — Tue, 08 Oct 2013 18:57:04 GMT

Hi-

In the Docs column in the DBXL Admin Tool, it looks like there are 0 documents. Is this correct?

When you submit your InfoPath form, does the number of Documents in the Document Type increase?

Re: Infopath submits succesful but SQL does not receive any data

Ruben337 — Tue, 08 Oct 2013 18:05:02 GMT

Thanks so much for the reply, I have been investigating your suggestions but it still isnt working so I have attached some screenshots here and maybe u see what I am doing wrong. I followed all the steps from module 1 and the pdf's but it is still updating the version history instead of creating a new document. I could delete Qdabra and install it again?

Re: Infopath submits succesful but SQL does not receive any data

ErnestoM — Mon, 07 Oct 2013 18:55:47 GMT

Hi, thanks for the additional info. There's a few things to address, so let me create a list below:

In order to reshred documents in the Documents tab you'll first have to select them (checkbox next to each document). Or you can click Reshred All.
Why is DbxlImportExport.asmx being used? If your form is submitting to the DBXL Document Service (using the operation SubmitDocument), then I don't see how DBXLImportExport would be used in the scenario.
Can you check whether the identity of the app pool (which I'm guessing is NT AUTHORITY\NETWORK SERVICE) has permissions to the database? You can check the QdabraDBXL database and compare its permissions with your own database's permissions.
The error "Invalid XML submitted to document type" suggests there's a problem in the XML being submitted. I don't know exactly what the problem is or why it's invalid, but maybe this is related to the first bullet. Once the form is using SubmitDocument correctly perhaps this "Invalid" message goes away.

Module 1 (or the Getting Started) should have info on using the DBXLDocumentService > SubmitDocument operation.

Re: Infopath submits succesful but SQL does not receive any data

Ruben337 — Mon, 07 Oct 2013 17:47:35 GMT

Hey, Thanks for your quick reply! I tried to reshred my documents but the button in DAT isn't clickable. I looked up the log and saw different errors so here they are. Hope u can tell me what I am doing wrong. I saw the requested login for SQL so I am gonna change that but the rest is a mystery to me. Thanks!! ImportDocuments encountered a critical error and needs attention: User: WIN-6SVIA9HHGM4\Patrick Url: /QdabraWebService/DbxlImportExport.asmx System.ArgumentException: The path is not of a legal form. at System.IO.Path.NormalizePathFast(String path, Boolean fullCheck) at System.IO.Path.GetFullPathInternal(String path) at System.IO.Directory.InternalGetFileDirectoryNames(String path, String userPathOriginal, String searchPattern, Boolean includeFiles, Boolean includeDirs, SearchOption searchOption) at System.IO.Directory.GetFiles(String path, String searchPattern, SearchOption searchOption) at Qdabra.Dbxl.Implementation.ServiceImplementation.ImportDocuments(String docTypeName, String folderPath, Boolean importExistingRefId) The stack trace was: at System.IO.Path.NormalizePathFast(String path, Boolean fullCheck) at System.IO.Path.GetFullPathInternal(String path) at System.IO.Directory.InternalGetFileDirectoryNames(String path, String userPathOriginal, String searchPattern, Boolean includeFiles, Boolean includeDirs, SearchOption searchOption) at System.IO.Directory.GetFiles(String path, String searchPattern, SearchOption searchOption) at Qdabra.Dbxl.Implementation.ServiceImplementation.ImportDocuments(String docTypeName, String folderPath, Boolean importExistingRefId). Caught exception testing connection string. encountered a critical error and needs attention: User: WIN-6SVIA9HHGM4\Patrick Url: /QdabraWebService/DbxlAdmin.asmx System.Data.SqlClient.SqlException: Cannot open database "Forms" requested by the login. The login failed. Login failed for user 'NT AUTHORITY\NETWORK SERVICE'. 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.SqlInternalConnectionTds.CompleteLogin(Boolean enlistOK) at System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, Int64 timerExpire, SqlConnection owningObject) at System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(String host, String newPassword, Boolean redirectedUserInstance, SqlConnection owningObject, SqlConnectionString connectionOptions, Int64 timerStart) at System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance) at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance) at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection) at System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options) at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject) at System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject) at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) at System.Data.SqlClient.SqlConnection.Open() at Qdabra.Dbxl.Implementation.ServiceImplementation.TestConnectionString(String ConnectionString, String& ErrorMessage, Boolean& Success) The stack trace was: 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.SqlInternalConnectionTds.CompleteLogin(Boolean enlistOK) at System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, Int64 timerExpire, SqlConnection owningObject) at System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(String host, String newPassword, Boolean redirectedUserInstance, SqlConnection owningObject, SqlConnectionString connectionOptions, Int64 timerStart) at System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance) at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance) at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection) at System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options) at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject) at System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject) at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) at System.Data.SqlClient.SqlConnection.Open() at Qdabra.Dbxl.Implementation.ServiceImplementation.TestConnectionString(String ConnectionString, String& ErrorMessage, Boolean& Success). Invalid XML submitted to document type: fqafqef 2013-10-08 by user:WIN-6SVIA9HHGM4\Patrick XML: encountered a critical error and needs attention. User: WIN-6SVIA9HHGM4\Patrick Url: /QdabraWebService/DbxlDocumentService.asmx

Re: Infopath submits succesful but SQL does not receive any data

ErnestoM — Mon, 07 Oct 2013 13:11:22 GMT

Hi-

Thanks for including the error information. Is that coming from the Application log? If so, the Qdabra log might have more info.

Another suggestion would be to try reshredding the documents from the DBXL admin tool.

Since the form is submitting successfully to DBXL, I assume the reshredding will tell us more about the mapping issue and why the documents are failing to go into the SQL database.

Let us know what you find. Thanks!

Infopath submits succesful but SQL does not receive any data

Ruben337 — Mon, 07 Oct 2013 09:38:25 GMT

Hey,

I am testing Qdabra (trail license) and so far its working great but I am running into a problem. I have made my own form (connected to a fresh database as reccomended) and followed all the steps from module 1 but now when i open my form and try to submit, Infopath says it is succesful but it updates the Version history in DAT instead of adding documents and sending data to SQL. The default expense report is working fine.

I am using Infopath 2010. and SQL 2008 R2

The following error occured in my Event log: Does it have anything to do with the error message Requested format is unrecognized?

Event code: 3005
Event message: An unhandled exception has occurred.
Event time: 10/6/2013 5:50:41 PM
Event time (UTC): 10/6/2013 3:50:41 PM
Event ID: 74c18c86b7c24524989075c3fb4652f4
Event sequence: 8
Event occurrence: 7
Event detail code: 0

Application information:
Application domain:
/LM/W3SVC/2073838747/ROOT/QdabraWebService-1-130255449660806478
Trust level: Full
Application Virtual Path: /QdabraWebService
Application Path:
C:\inetpub\wwwroot\wss\VirtualDirectories\80\QdabraWebService\
Machine name: WIN-6SVIA9HHGM4

Process information:
Process ID: 3344
Process name: w3wp.exe
Account name: NT AUTHORITY\NETWORK SERVICE

Exception information:
Exception type: HttpException
Exception message: Request format is unrecognized.

Request information:
Request URL:
http://win-6svia9hhgm4/qdabraWebService/DbxlDocumentService.asmx?op=SubmitDocument
Request path: /qdabraWebService/DbxlDocumentService.asmx
User host address:
fe80::b540:6f93:9349:90fdC:\inetpub\wwwroot\wss\VirtualDirectories\80\QdabraWebService\
User: WIN-6SVIA9HHGM4\Patrick
Is authenticated: True
Authentication Type: Negotiate
Thread account name: NT AUTHORITY\NETWORK SERVICE

Thread information:
Thread ID: 3
Thread account name: NT AUTHORITY\NETWORK SERVICE
Is impersonating: False
Stack trace: at
System.Web.Services.Protocols.WebServiceHandlerFactory.CoreGetHandler(Type
type, HttpContext context, HttpRequest request, HttpResponse response)
at System.Web.Services.Protocols.WebServiceHandlerFactory.GetHandler(HttpContext
context, String verb, String url, String filePath)
at System.Web.HttpApplication.MapHttpHandler(HttpContext context,
String requestType, VirtualPath path, String pathTranslated, Boolean
useAppConfig)
at System.Web.HttpApplication.MapHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
at System.Web.HttpApplication.ExecuteStep(IExecutionStep step,
Boolean& completedSynchronously)