Aware IM User Forums

[aware_support]

I think we have reproduced it - thanks a lot, Pete, please ignore my last request
_________________
Aware IM Support Team

[pbrad]

okay great, let me know if you need a sqldump of the dv_res table and an extract of the templates directory. Glad to hear that I wasn't crazy.
Cheers,
Pete
_________________
Pete Bradstreet
Contract Developer & Hosting Services

Please visit: www.awareim-toolkit.com

Latest In-House Project: www.iportcentral.com
Latest Commercial Project: www.clixongroup.com

AwareIM Ver. 5.6

[aware_support]

We have just released build 1533 where this issue should be fixed.

Unfortunately, if you have already hit this problem in the previous release you will need to manually change the database to get rid of the problem. To do this issue the following SQL command (assuming the problem is in the business space called MyBS):

SELECT DataKey FROM DV_RES WHERE DataKey LIKE 'MyBS%';

or if working in testing mode:

SELECT DataKey FROM DV_RES WHERE DataKey LIKE 'BASTestDomainMyBS%';

You will see a list of resources for your business space. Your document template (.rdd) will have two entries, for example:

MyBS/DocTemplates/101/101/RDDoc5678.rdd
MyBS/DocTemplates/101/101/RDDoc5678893048394.rdd

The shorter one will be the old document, the longer one will be the modified document. You need to delete the old one, for example

DELETE from DV_RES WHERE DataKey='MyBS/DocTemplates/101/101/RDDoc5678.rdd';
_________________
Aware IM Support Team

[Powerm]

FYI, Try to do it with blank version of CRM app :

- create blank CRM app
- create dummy report with any field inside, design and save
- test BSV
- publish and export BSV
- create new minor version
- publish version
- try to export and it will give the double dummy.rdd template error
Deleting the DocTemplates folder does not help and I can't see double rdd there. On table DV_RES I see the version 1.54 of my BSV despite having published version 1.63.


AwareIm 5.3 running on OSX Lion Server, Mysql

[Powerm]

sorry support, seen your fix after posting. Will try the fix, thanks.

[JayBell]

Hi guys, I too have this problem on build 1528. Could someone tell me how to issue the SQL command please? Do I create a process in my BSV to do it or am I missing some option from the Configuration Tool?

Also, once I've done this where do I find build 1533?

Sorry for the very newbie style questions

Thanks

Jay

[Powerm]

Download here ( trials ) or if you have a license login to your account in aware site : http://www.awareim.com/downloads.html
Regarding the mysql commands I have used myself Navicat to connect to my database table and delete directly from there without using commands :
http://www.navicat.com/

[tford]

[JayBell]

I'm afraid I dont have navicat or any other suitable tool (although it's a good idea, I must sort that!) I added the SQL statement to a query in my BSV with the intention of running it from my Standard menu. However, when I try to publish my version I get integrity check: "Query Fix1 uses business object 'RES' which has not been found'

On a plus note the upgrade to latest version went smoothly thanks

[aware_support]

Jay, do not add these SQL commands to your BSV - do it outside of Aware IM. Are you using MySQL? If so, either install Navicat or use the mysql utility that comes with MySQL. Check the MySQL documentation how to start it. Once inside this utility enter the following SQL command to switch to the Aware IM database:

USE BASDB;

and then issue the SQL commands as advised
_________________
Aware IM Support Team

[JayBell]

I'm using Derby - can you advise a free tool for that please?

[BobK]

To access Derby, take a look at SQuirreL. See posting http://www.awareim.com/phpBB2/viewtopic.php?t=1453&highlight=squirrel
_________________
Bob
Version 5.3 Build 1548, MySQL Version 5.1