Developer forum

Forum » PIM » Setting default image YSOD

Setting default image YSOD

Nuno Aguiar Dynamicweb Employee
Nuno Aguiar
Reply

Hi,

 

Using 9.13.6, we're trying to assign a default image manualy to a product and we're getting an exception (YSOD). I am attaching the image, a link to the screencast for the repro steps and the stack trace. 

What's odd, is that we've been doing this and had no issues previously. Any thoughts why this would start to happen?

 

https://www.screencast.com/t/KkdwBafrj2wN

 

Server Error in '/' Application.


Incorrect syntax near 'U'.

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.Data.SqlClient.SqlException: Incorrect syntax near 'U'.

Source Error:

 

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.


Stack Trace:
 

[SqlException (0x80131904): Incorrect syntax near 'U'.]
   System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) +3331296
   System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) +334
   System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) +4289
   System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted) +514
   System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest) +3392
   System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) +725
   System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) +551
   System.Data.SqlClient.SqlCommand.ExecuteNonQuery() +391
   Dynamicweb.Data.Database.ExecuteNonQuery(IDbCommand command) +521
   Dynamicweb.Data.Database.ExecuteNonQuery(CommandBuilder commandBuilder, IDbConnection connection, IDbTransaction transaction, Int32 commandTimeout) +102
   Dynamicweb.Data.Database.ExecuteNonQuery(CommandBuilder commandBuilder, IDbConnection connection, Boolean useTransaction, Int32 commandTimeout) +197
   Dynamicweb.Data.Database.ExecuteNonQuery(CommandBuilder commandBuilder, Boolean useTransaction, Int32 commandTimeout) +58
   Dynamicweb.Ecommerce.Products.DetailRepository.Save(Detail detail, String detailProductId, String detailVariantId) +715
   Dynamicweb.Ecommerce.Products.DetailService.Save(Detail detail, String detailProductId, String detailVariantId) +159
   Dynamicweb.Admin.eComBackend.PimManageImages.HandleCommand(String cmd) +943
   Dynamicweb.Admin.eComBackend.PimManageImages.Page_Load(Object sender, EventArgs e) +92
   System.Web.UI.Control.OnLoad(EventArgs e) +108
   System.Web.UI.Control.LoadRecursive() +90
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1533
DELL_MONITOR.jpg

Replies

 
Oleg Rodionov Dynamicweb Employee
Oleg Rodionov
Reply

Hi Nuno,

The issue (I see the exception on adding image even not set as default and saving after it) is bugged by task 7728 has been created. Thanks for observing.

BR, Oleg QA 

 
Nuno Aguiar Dynamicweb Employee
Nuno Aguiar
Reply

Thanks Oleg

 
Gunnar Örn Baldursson
Reply

Hi,

we just got contacted by a customer because of this issue. do you have an ETA for when a patch is available that I can report back to them?

 
Dynamicweb Employee
Jason Harwell
Reply

I am also having the same issue on another project. 

 
Oleg Rodionov Dynamicweb Employee
Oleg Rodionov
Reply

Hi,

the fix is already under developing, I hope it will be provided with next upcoming DW release. Sorry for inconvenience.

BR, Oleg QA

 

You must be logged in to post in the forum