Example DV project: Term Frequency Analysis

Question

Summary

Content

Upgraded to v4 today - lots of new features - the machine learning particularly interested me so I downloaded the above from the OA Library, the project and data are fine when I try to inspect or run the associated script ('Term frequency analysis (py)') I am getting a 'General error was found', tried full un-install and re-install.

Detailed script when running query...

Error occurred while processing the query.select "term" as "term", "frequency" as "frequency"from EVALUATE_TABLE_SCRIPT('''weblogic''.''Term Frequency Analysis (py)''', 'topn=25;includeInputColumns=false;', Select "Claim Description" as "text" from (select "Claim Id" as "Claim Id", "Dealer" as "Dealer", "Dealer State" as "Dealer State", "Dealer City" as "Dealer City", "Claim Date" as "Claim Date", "Claim Month" as "Claim Month", "Claim Description" as "Claim Description", "Claim Age" as "Claim Age", "Claim Age Bucket" as "Claim Age Bucket", "Vehicle Make" as "Vehicle Make", "Vehicle Model" as "Vehicle Model", "Veh. Drive Train" as "Veh. Drive Train", "Veh. Months In Service" as "Veh. Months In Service", "Num Cyls" as "Num Cyls", "Veh. Prod. Month" as "Veh. Prod. Month", "Veh. Prod Date" as "Veh. Prod Date", "Veh. Build Region" as "Veh. Build Region", "Veh. Id VIN" as "Veh. Id VIN", "Labor Task" as "Labor Task", "Commodity Part" as "Commodity Part", "Part Supplier Country" as "Part Supplier Country", "Part Supplier State" as "Part Supplier State", "Part Supplier" as "Part Supplier", "Num of Claims" as "Num of Claims", "Labor Cost" as "Labor Cost", "Parts Cost" as "Parts Cost", "Total Cost" as "Total Cost"from XSA('weblogic'.'Auto Insurance Claims').input."Auto Insurance Claims") ApplyScript_0_Internal) FETCH FIRST 30 ROWS ONLY

Olivier Sinquin · Answer

I had not seen the requirement either :-)

A colleague told me about it after I had banged my head on the wall for a few hours.

I agree that if we can't install DVML with DVD for licensing reasons (which I doubt because getting rid of the GNU licensing constraint was the point beyond moving from R to Pyhton) then they should put some type of message or warning, like they did for Advanced Analtycs (AKA R )

Alan Walsh · Answer

I haven't - didn't spot that as a requirement, with the advanced analytics it gives you a clue that you need to do something else, the general error message isn't very helpful. I'll give it a go and advise on update (feeling slightly dim for not spotting it )

Olivier Sinquin · Answer

have you installed the new DVML thing (and possibly the Advanced Analytics thing too)?