ERROR in data exchange with site (data synchronization)

Powerful and flexible application for small business management. See 1C:Small Business description

#1
People who like this:0Yes/0No
Just came
Rating: 1
Joined: Jun 30, 2014
Company:

I filled necessary fields in "Exchange nodes with sites" correctly. But when I try to push "Execute full data exchange"  button to dump products and exchange orders, it gives ERROR below:


Code
{(283, 3)}: Table name expected
<<?>> To TemporaryTablePrices.Characteristic = NomenclatureCharacteristicAdditionalAttributes.Ref


What's the problem? How to fix?


I use
1C enterprise (8.3.4.496)
Small Business (1.4.7.38)

Download error.jpg (55.55 KB)
Edited: Orçun Oruç Aykaç - Jul 01, 2014 10:42 PM
 
#2
People who like this:0Yes/0No
Timofey Bugaevsky
Guest

Joined:
Company:

Hello, Orçun Oruç Aykaç!

Thank you for joining 1C:Developer Network and I'm sorry that you have this problem.

I have escalated your request to the developer team. You will have a reply as soon as possible.

 
#3
People who like this:0Yes/0No
Just came
Rating: 1
Joined: Jun 30, 2014
Company:

OK. Please reply as soon as possible.

 
#4
People who like this:0Yes/0No
Just came
Rating: 1
Joined: Jun 30, 2014
Company:

Hello Timofey.

I am still waiting for the solution. It's important for me. I have purchased 1C because I only need  this feature (exchange with site).

Please hurry up.

 
#5
People who like this:0Yes/0No
Timofey Bugaevsky
Guest

Joined:
Company:

Orçun Oruç Aykaç, the updated release of 1C:Small Business is coming soon. Sorry for the delay.

 
#6
People who like this:0Yes/0No
Active user
Rating: 2
Joined: Apr 23, 2014
Company: Altair d.o.o.

Replace in Designer in text of query word "To" => "ON".  :)

Edited: Dmytro Kalchenko - Jul 02, 2014 06:06 AM
 
#7
People who like this:0Yes/0No
Just came
Rating: 1
Joined: Jun 30, 2014
Company:

Quote
Replace in Designer in text of query word "To" => "ON".  :)

It doesn't work. It gives different errors.

Edited: Orçun Oruç Aykaç - Jul 02, 2014 10:39 PM
 
#8
People who like this:0Yes/0No
Active user
Rating: 2
Joined: Apr 23, 2014
Company: Altair d.o.o.

What error? I can help you if you lay out a screenshot on the forum.

P.S. There are two queries in this module. Replace 'To' => 'ON' twice.

Edited: Dmytro Kalchenko - Jul 03, 2014 04:31 AM
 
#9
People who like this:0Yes/0No
Just came
Rating: 1
Joined: Jun 30, 2014
Company:

I changed "To"  ->  "ON" in the code in Common Modules -> ExchangeWithSite Module. Here is the code part I have changed.

Code
|SELECT DISTINCT
      |   TemporaryTablePrices.Characteristic AS Characteristic,
      |   NomenclatureCharacteristicsAdditionalAttributes.Property AS Property,
      |   NomenclatureCharacteristicsAdditionalAttributes.Value AS Value
      |FROM
      |   TemporaryTablePrices AS TemporaryTablePrices
      |      INNER JOIN Catalog.NomenclatureCharacteristics.AdditionalAttributes AS NomenclatureCharacteristicsAdditionalAttributes
      |      To TemporaryTablePrices.Characteristic = NomenclatureCharacteristicsAdditionalAttributes.Ref
      |Totals BY
      |   Characteristic
      |;



But it gives a new, different error. Here is the new error:

Edited: Orçun Oruç Aykaç - Jul 04, 2014 12:04 AM
 
#10
People who like this:0Yes/0No
Timofey Bugaevsky
Guest

Joined:
Company:

By the way, while you are waiting for the new release, take a look at Publish functionality of 1C:Translator application. This application provides both examples:

  • 1C:Enterprise-side publishing script (PublicationOverridable common module, triggered by Publish button).
  • Bitrix CMS publication web service (PublicationWebServiceBitrix common template, can be saved as ZIP from Project item form).

 
#11
People who like this:0Yes/0No
Timofey Bugaevsky
Guest

Joined:
Company:

Hello, Orçun Oruç Aykaç.

1C:Small Business 1.4.7.39 released. Please check, if your problem is fixed.

 
#12
People who like this:0Yes/0No
Just came
Rating: 1
Joined: Jun 30, 2014
Company:

Download link is broken. https://1c-dn.com/files/updates/1c_small_business/1_4_7_39/solution.zip  
 
Page Not Found! (Code 404)

 
#13
People who like this:0Yes/0No
Just came
Rating: 1
Joined: Jun 30, 2014
Company:

I have downloaded ver. 1.4.7.39 of Small Business and installed applied solution (in Demo installer). I have created an “Exchange nodes with sites” and tested it. When I try to push “Execute full data exchange” button, I get this ERROR below:

Code
{CommonModule.ExchangeWithSite.Module(1273)}: Error calling context method (Create)
   BusinessInformationXTDO = XDTOFactory.Create(BusinessInformationType);
because:
Type mismatch (parameter number '1')

See screenshot below.

When I try to push “Execute data exchange” button, it says “Exchange with sites completed” but nothing is added in web site. No categories or no products.


PS: BTW, I work on localhost.

Edited: Orçun Oruç Aykaç - Jul 06, 2014 10:28 PM
 
#14
People who like this:0Yes/0No
Timofey Bugaevsky
Guest

Joined:
Company:

I'm sorry, the link is fixed.

How did you implement the data synchronization web services on your website?

 
#15
People who like this:0Yes/0No
Just came
Rating: 1
Joined: Jun 30, 2014
Company:

As shopping cart I use CS CART.

And as the addon I use 1C: Enterprise Add-on developed by Simtech Development. I know this addon works in 1C Trade Management ver. 11 in Russian.


I am trying to use this addon and 1C Small Business together but it gives errors I have mentioned above.

I contacted to developer of the addon. They said you should contact to 1C developers and fix the errors. Now I am still waiting you to fix the errors.

Edited: Orçun Oruç Aykaç - Jul 08, 2014 05:46 AM
 
#16
People who like this:0Yes/0No
Timofey Bugaevsky
Guest

Joined:
Company:

I'm sorry, but the English version was not tested to be compatible with Simtech Development. I will let developers know regarding this issue.

 
#17
People who like this:0Yes/0No
Just came
Rating: 1
Joined: Jun 30, 2014
Company:

OK. Please let them test it and provide the addon work properly.

I will be waiting for your reply.

 
#18
People who like this:0Yes/0No
Active user
1C:Professional
Rating: 8
Joined: Jun 25, 2013
Company: 1C Company

The new version of 1C:Small business with several bugfixes is released. Check it out.

1C Company support team
 
Subscribe
Users browsing this topic (guests: 1, registered: 0, hidden: 0)
Be the first to know tips & tricks on business application development!

A confirmation e-mail has been sent to the e-mail address you provided .

Click the link in the e-mail to confirm and activate the subscription.